Re: [PHP-DB] LAST_INSERT_ID?????

2004-07-15 Thread Justin Patrin
On Thu, 15 Jul 2004 16:25:26 -0400, Hutchins, Richard <[EMAIL PROTECTED]> wrote: > Scott, > > I typically use PHP's mysql_insert_id() function on a result. For example, > the following snippet from a function I use: > > > $result = mysql_query($sql) or > die(mysql_error()

RE: [PHP-DB] LAST_INSERT_ID?????

2004-07-15 Thread Hutchins, Richard
Scott, I typically use PHP's mysql_insert_id() function on a result. For example, the following snippet from a function I use: $result = mysql_query($sql) or die(mysql_error()); if(!$result){ $evNew = -1;//set evID to an impossible

Re: [PHP-DB] LAST_INSERT_ID?????

2004-07-15 Thread Justin Patrin
Try the PHP funciton mysql_insert_id(). http://us3.php.net/manual/en/function.mysql-insert-id.php On Thu, 15 Jul 2004 15:16:44 -0500, NIPP, SCOTT V (SBCSI) <[EMAIL PROTECTED]> wrote: > OK. I know that a BUNCH of people have had this question, and I > have read numerous Google threads on

RE: [PHP-DB] LAST_INSERT_ID()

2002-03-21 Thread Rick Emery
I mean: mysql_insert_id() -Original Message- From: Rick Emery [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 21, 2002 2:28 PM To: 'Morten Nielsen'; [EMAIL PROTECTED] Subject: RE: [PHP-DB] LAST_INSERT_ID() use mysql_last_id() -Original Message- From: Mort

RE: [PHP-DB] LAST_INSERT_ID()

2002-03-21 Thread Rick Emery
use mysql_last_id() -Original Message- From: Morten Nielsen [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 21, 2002 2:30 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] LAST_INSERT_ID() Hi, In the PHP manual under the function mysql_insert_id() function they have the following line: The