Insert data to DB

[dprevite]

I am inserting data into a db with an id number that is auto incremented. What is the best way to get the id number that MySQL gives that record?

This is what I'm doing now:

mysql_query("INSERT INTO charts (id, userID, month, year) VALUES ('', 2313, 10, 2003)");

then

$result = mysql_query("SELECT id FROM charts WHERE userID=2313 AND month=10 AND year=2003");

Is there an easier way to do this? All in one query would be nice. I'm not that great with MySQL so thanks for the help!

[drawmack]

For the second query

$result = mysql_query("SELECT MAX(id) FROM charts");

since it is an auto_increment field then the highest numbered record will be the most recently inserted.

WARNING: put these two lines of code as close together as possible if someone else's insert runs between your insert and your select you'll have the wrong ID.

[jayant]

Use [man]mysql_insert_id/man

<?php
    mysql_query("INSERT INTO charts (id, userID, month, year) VALUES ('', 2313, 10, 2003)");
    $last_insert_id = mysql_insert_id();
?>

[ctimmer]

Jayant's method is safer, especially if there is any chance that there will be more than one user updating concurrently.