How can I retrieve the AUTO_INCREMENT ID

[Anon]

Hi,
In MySql, I had a table with a AUTO_INCREMENT column, when I insert a row to it, how can I retrieve this column ID value?

Thnks...

[Anon]

You can do it by using mysql_insert_id.

lancelot_

[Anon]

for example:

$query = mysql_query("INSERT INTO table (field) VALUES ('foo')");
$genID = mysql_insert_id();