mysql query using INSERT

[Crump]

Here is my situation:
I perform a INSERT statement in to a table. The table has a auto_increment column. So I do the INSERT, and it automatically creates a value in that column.

Now, is there a way to get that value? The only thing I can think of is after doing the INSERT, do a SELECT with some of the values that I used in the INSERT, but I am afraid of duplicate entries.

Any ideas?

[grandpa]

mysql_insert_id [php.net] should get it for you

mysql_insert_id -- Get the ID generated from the previous INSERT operation

[coopster]

Although PHP supplies us with the mysql_insert_id() [php.net] function, we may be better of not using it. There is a warning in the manual regarding certain column types and a known issue, therefore I use the internal MySQL SQL function LAST_INSERT_ID() [dev.mysql.com] in an SQL query instead.