Sam, Thanks, I got the mysql_insert_id() tip a few seconds earlier.
However, my alternative method (which I will now drop in the interests of efficiency) is perfectly safe. It is impossible for the same user to go and create another record in that verys small interim period between the two queries. That was why the WHERE user='$user' was there. George ----- Original Message ----- From: "Sam Masiello" <[EMAIL PROTECTED]> To: "George Pitcher" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, January 14, 2002 3:21 PM Subject: Re: [PHP-DB] grabbing id from new record > > That actually isn't a safe way to do it. Consider the following scenario: > > Insert A occurs generating row Y in your table. > Insert B occurs generating row Z in your table. > select occurs (after insert A) to grab last ID inserted...your result is the > ID from row Z. > select occurs (after insert B), and your result again is the result ID from > row Z. > > So, in both cases you will get the ID from insert B, instead of your > intended result (first select gives the ID from row Y and the second from > row Z). > > You didn't mention which database engine that you are using, so I will > assume you are using MySQL. There is a function called mysql_insert_id() > that will give you the answer that you are looking for. You can find more > information about it here: > http://www.php.net/manual/en/function.mysql-insert-id.php > > HTH > > Sam Masiello > Software Quality Assurance Engineer > Synacor > (716) 853-1362 X289 > [EMAIL PROTECTED] > > ----- Original Message ----- > From: "George Pitcher" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Monday, January 14, 2002 9:23 AM > Subject: [PHP-DB] grabbing id from new record > > > > Hi, > > > > Is there a way to grab the ID (from ID field) while INSERTing a new > record? > > > > I am currently doing a separate INSERT then a SELECT query to find the > most > > recently added record by that user: > > > > select ID from table where user = '$user' order by ID DESC limit 0,1 > > > > This does the trick but it may not be the most efficient way. > > > > George > > > > > > --- > > Outgoing mail is certified Virus Free. > > Checked by AVG anti-virus system (http://www.grisoft.com). > > Version: 6.0.307 / Virus Database: 168 - Release Date: 11/12/01 > > > > > > _________________________________________________________ > > Do You Yahoo!? > > Get your free @yahoo.com address at http://mail.yahoo.com > > > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.307 / Virus Database: 168 - Release Date: 11/12/01 _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
