execute the following query: SELECT LAST_INSERT_ID();
Peter -----Original Message----- From: marc serra [mailto:[EMAIL PROTECTED] Sent: dinsdag 17 februari 2004 20:17 To: [EMAIL PROTECTED] Subject: [PHP] auto increment Hi, i use PEAR DB with a mysql database and i want to know if there is a solution to get last inserted id in a table. I see that I can use sequences but it doesn't work with mysql. Thanks, Marc. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

