jasonc Posted June 9, 2006 Share Posted June 9, 2006 I wish to find out how i can get the id of the most recent item added to the mysql databaseThe 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 advanceEdit/Delete Message Link to comment https://forums.phpfreaks.com/topic/11614-obtain-new-id-of-new-item-added-to-mysql-table/ Share on other sites More sharing options...
yonta Posted June 9, 2006 Share Posted June 9, 2006 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] Link to comment https://forums.phpfreaks.com/topic/11614-obtain-new-id-of-new-item-added-to-mysql-table/#findComment-43857 Share on other sites More sharing options...
radalin Posted June 10, 2006 Share Posted June 10, 2006 if you use pear::db or pear::mdb2 you can use nextID() method of db class Link to comment https://forums.phpfreaks.com/topic/11614-obtain-new-id-of-new-item-added-to-mysql-table/#findComment-43955 Share on other sites More sharing options...
fenway Posted June 10, 2006 Share Posted June 10, 2006 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. Link to comment https://forums.phpfreaks.com/topic/11614-obtain-new-id-of-new-item-added-to-mysql-table/#findComment-43960 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.