Retrieve ID in mySQL

[duckax]

I have a table with a "auto_increment primary key" field. When I insert a new row using PHP, is there a way to immediately know what is the value of that field?

Running a second select command seems kinda wasteful. Just checking if there is a better way.

[agoossens]

Yep: mysql_insert_id(). Check out the manual page for it.

[duckax]

Thanks! Thats what I'm looking for.