How to get identifier after INSERT new Data?

[andreas123]

Hello,
I work with PHP and MySQL. How can I get the identifier, which was created by MySQL (auto_increment) after creating a new row in a table with
"INSERT INTO tableName (colums) VALUES (data)"
(The data are not always unique so I need the automatic created ID of this INSERT-Query.)
regards Andreas

 

[Broccoli2]

$id=mysql_insert_id()

should do it.

-Rob

 

[andreas123]

Wow, thats it. Thank you very much Rob.