php/mysql - getting ID of query

From: Date: Tue, 21 Aug 2007 20:58:22 +0000
Subject: php/mysql - getting ID of query
Groups: php.general 
Request: Send a blank email to php-general+get-261094@lists.php.net to get a copy of this message
This is as much a mysql question as it is php. What is the most reliable way to retrieve an auto_increment key/id for a query you just inserted? In other words, I compile all my data, insert it into a new row, and now I want to retrieve the ID it created for it in the ID/key field. Without turning around and searching for the values I just inserted, is there a way to get the ID? The ID is the only field that is guaranteed to be unique in each data set, which makes it questionable to search for the data you just inserted, unless you searched for the *whole* data set. Thanks John

« previous php.general (#261094) next »