Re: Adding Records & Capture The New Record ID

At 12:12 PM -0800 2/7/09, revDAVE wrote:

On 2/7/2009 11:41 AM, "Stuart" <stuttle@gmail.com> wrote:

Then, after I inserted the record - I would do a quick query that would retrieve the record ID by searching for the random number

Ouch that's nasty!!

Q: is there a better way to retrieve the record ID from the newly added record?

Use an auto_increment field then, assuming MySQL you can use

mysql_insert_id to get the ID of the last record inserted on a given

connection. -Stuart

Thanks Stuart - it works great - so much Less Nasty! BTW: as long as - mysql_insert_id is right after the insert statement - is it 100% accurate - (in that no other insert from another user could get in the middle of this)?

That's one way, to use "mysql_insert_id" (probably the best). But another is simply to read back in the record you just created and check the $row['id']. That's the way I do it sometimes. Cheers, tedd -- ------- http://sperling.com http://ancientstones.com http://earthstones.com