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] Testing MySQL failed ???

2001-03-31 Thread Felix Kronlage
On Sun, Apr 01, 2001 at 06:05:28PM +0800, Szeto wrote: > the MySQL is on coz, it show in > > > Warning: MySQL Connection Failed: Can't connect to local MySQL server > > > through socket '/var/lib/mysql/mysql.sock' (111) in is there a socket in /var/lib/mysql ? -fkr -- gpg-fingerprint: 076E 1E

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: > .. '; > 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 not sure right now, but try $color["color_1

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] 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 And read the file line by line, match every line with a regexp. If you hit the line start stuffing the lines in array. Once you hit the line st

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"]."\n"; ^^ missing a '.' there. either this way echo "Name:

Re: [PHP-DB] Date

2001-03-25 Thread Felix Kronlage
On Sun, Mar 25, 2001 at 03:02:21PM +0200, [EMAIL PROTECTED] wrote: > I save the date in my MySQL db as 2001-03-25. > But in my PHP script i want do see it like 25-03-2001. > How do i get this result if you can't modify the formart the date is safed as, you could use split on the string that comes

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.