Obtain new id of new item added to mysql table
Posted 09 June 2006 - 09:12 PM
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
Posted 09 June 2006 - 09:46 PM
$recordid = mysql_insert_id();
Check it out [a href=\"http://pt.php.net/mysql_insert_id\" target=\"_blank\"]here[/a]
Posted 10 June 2006 - 08:19 AM
SELECT LAST_INSERT_ID()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.
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users