hi
you can use the mysql function LAST_INSERT_ID()
heres the info from the manual:
http://dev.mysql.com/doc/mysql/en/ODBC_and_last_insert_id.html
hope that helps
eoghan
Nathan Mealey wrote:
Is there a PEAR::DB equivalent to the mysql_insert_id()? I can't figure
out how to get the primary key ID
Is there a PEAR::DB equivalent to the mysql_insert_id()? I can't figure
out how to get the primary key ID from the last insert query, without
doing a second query (which seems ridiculous).
On that same note, are the mysql_insert_id() and pg_last_oid()
equivalent? I thought they were, but when