You can select max(aifield) immediately after the insert. :-) <>< Ryan
-----Original Message----- From: Stéphane [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 02, 2002 11:57 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Retrieve auto_increment value after an insert with ODBC Hi, I use php and db2 database. I wonder if there is a way to retrieve the value of an auto-increment id after an insert query. (Like mysql_insert_id on MySQL database.) The temporary solution is to select record with the same values than the insert. Any others solutions? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php