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