Re: [PHP-DB] Get the id generated from the previous INSERT operation

2001-05-06 Thread Felix Kronlage
On Sun, May 06, 2001 at 07:22:24PM +0200, Alpha wrote: mysql_insert_id - Get the id generated from the previous INSERT operation So how do I do that in ms-sql? as sql it should be something like '@@IDENTITY'don't know if there is a php-function for it, just worked with ms-sql via java.

Re: [PHP-DB] Testing MySQL failed ???

2001-03-31 Thread Felix Kronlage
On Sun, Apr 01, 2001 at 06:50:24PM +0800, Szeto wrote: I am new to Linux environment so what. You could still read the error-message: | Warning: MySQL Connection Failed: Can't connect to local MySQL server | through socket '/var/lib/mysql/mysql.sock' (111) in this suggests, that you

Re: [PHP-DB] fetch array problems.

2001-03-28 Thread Felix Kronlage
On Wed, Mar 28, 2001 at 01:08:35AM -0700, John Starkey wrote: table bgcolor="'.$color[color_1].'" class="nav" .. '; I can't get $color[color_1] to return a value. It's in the db and color_1 is a valid table containing a hex value. This is my first attempt at using assoc. arrays. I'm

Re: [PHP-DB] Read lines

2001-03-26 Thread Felix Kronlage
On Mon, Mar 26, 2001 at 12:38:38PM +0200, [EMAIL PROTECTED] wrote: don't know why this is on php-db I want to read lines from a file between !--begin-- And !--End-- read the file line by line, match every line with a regexp. If you hit the line !--begin-- start stuffing the lines in

Re: [PHP-DB] How to print last row in an array using WHILE?

2001-03-26 Thread Felix Kronlage
On Mon, Mar 26, 2001 at 10:35:37PM -0800, Bob Stone wrote: Everything works fine except that only n-1 rows from the array will display. no wonder (explained below at the code) This fetches the first row $myrow = mysql_fetch_array($result); ...and then the rest in the while-loop.

Re: [PHP-DB] Help?

2001-03-25 Thread Felix Kronlage
On Mon, Mar 26, 2001 at 09:24:38PM -0800, Chris Hall wrote: Parse error: parse error, expecting `','' or `';'' in f:\inetpub\wwwroot\forums\index.php on line 38 line 38 would be: echo "Name: "$row["user_id"]."br\n"; ^^ missing a '.' there. either this way echo "Name:

Re: [PHP-DB] file name extentions

2001-03-24 Thread Felix Kronlage
On Sat, Mar 24, 2001 at 12:40:48PM +0100, Dan Eskildsen wrote: I have tired using the filenmae file.php but the server will not execute the file. This depends on the configuration of the webserver. The webserver needs to be told which file-suffixes should be used to identify files to parse.