get autoincrement key after MySQL insert 1

[RobBroekhuis]

When I insert a new record into a MySQL table using a call like
$result=mysql_query("insert into....",$db);

is there any way to get the key (auto-increment) that MySQL assigns to the new record from the $result, or do I have to execute another query to find that one out?


Rob

 

[sleipnir214]

http://us4.php.net/manual/en/function.mysql-insert-id.php

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[RobBroekhuis]

I figured it was easy... Thanks!


Rob