> Hi there, > > I seem to be having a problem retrieving the last inserted ID for a > table. > > The query I am using is as follows: >
It's far easier than anyone else has mentioned, as of my writing. Just use the PHP function 'mysql_insert_id()' after your insert query. This function has been in the PHP MySQL module since at least sometime during the version 3 cycle. Here's the address to the online PHP documentation for the MySQL module: http://www.php.net/manual/en/ref.mysql.php -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]