Obtain new id of new item added to mysql table

[jasonc]

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

[yonta]

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]

[radalin]

if you use pear::db or pear::mdb2 you can use nextID() method of db class

[fenway]

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.