Re: [PHP-DB] last insert ID

2005-01-03 Thread list
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

[PHP-DB] last insert ID

2005-01-02 Thread Nathan Mealey
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