RE: [PHP-DB] mysql_insert_id() vs. last_insert_id()

2003-01-29 Thread Hutchins, Richard
Any further thoughts? Rich > -Original Message- > From: Randy Phillips [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, January 29, 2003 9:30 AM > To: [EMAIL PROTECTED] > Subject: Re: [PHP-DB] mysql_insert_id() vs. last_insert_id() > > > on 1/28/03 11:42 AM, Jo

Re: [PHP-DB] mysql_insert_id() vs. last_insert_id()

2003-01-29 Thread Randy Phillips
on 1/28/03 11:42 AM, John W. Holmes at [EMAIL PROTECTED] wrote: >> The reason I ask is, if you use mysql_insert_id() on a busy server and > it >> does not function on a per-connection basis, don't you run the risk of >> getting the last ID of somebody else's INSERT query on the server? > > Yes, t

RE: [PHP-DB] mysql_insert_id() vs. last_insert_id()

2003-01-28 Thread John W. Holmes
> So I read this thread and the MySQL doc on mysql_insert_id() and still > have > a related question. > > Does mysql_insert_id() function on a per-connection basis? I read the > stuff > on last_insert_id() and it specifically mentions that the last ID is > stored > on the server on a per-connectio

RE: [PHP-DB] mysql_insert_id() vs. last_insert_id()

2003-01-28 Thread Hutchins, Richard
ginal Message- > From: 1LT John W. Holmes [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, January 28, 2003 11:37 AM > To: Randy Phillips; [EMAIL PROTECTED] > Subject: Re: [PHP-DB] mysql_insert_id() vs. last_insert_id() > > > > I've been checking the last_insert_

Re: [PHP-DB] mysql_insert_id() vs. last_insert_id()

2003-01-28 Thread 1LT John W. Holmes
> I've been checking the last_insert_id() function out and I am curious. The > MySQL docs say to use the mysql_insert_id() function after an "insert into" > query to grab the key value. Both seem to work; however, there are some > subtle differences. > > Which is the best one to use after a single