Jump to content

Archived

This topic is now archived and is closed to further replies.

jasonc

Obtain new id of new item added to mysql table

Recommended Posts


I wish to find out how i can get the id of the most recent item added to the mysql database

The ID is set by the mysql database by increasing by one to the last entry.

I need to find the best way to find out what this number is.

can someone please advise how this can be done.

thank you in advance
Edit/Delete Message

Share this post


Link to post
Share on other sites
Just after the insert query do a call like this:

$recordid = mysql_insert_id();

Check it out [a href=\"http://pt.php.net/mysql_insert_id\" target=\"_blank\"]here[/a]


Share this post


Link to post
Share on other sites
if you use pear::db or pear::mdb2 you can use nextID() method of db class

Share this post


Link to post
Share on other sites
Or just issuing a

[code]SELECT LAST_INSERT_ID()[/code]
directly to the DB. It's by connection, so you don't need to worry about race conditions. But be careful about multi-valued insert statements and INSERT INGOREs, since they behave "as documented" but strangely nonetheless.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.