Finding id of new row after insert

Hey,


I have a table with the primary key being an auto-increment integer ID.

If I insert a new record using something like this:

$conn = mysql_connect ('localhost' , $dbUser , $dbPass);
$db    = mysql_select_db ($dbName , $conn);

$sql     = "INSERT into table_name VALUES (NULL , 'value 1', 'value 2' etc...)";
$result = mysql_query ($sql , $conn);

PHP:

What would be the best way to find out the ID of the new record?


Thanks,

Hodge

 

mysql_insert_id()

 

I think you're looking for the mysql_insert_id() function.

 

Awesome that's exactly what I need - thanks

 

Select Last_inserted_id();

 

I used to query the database to get the id. Thanks a lot. A very useful function