[Resolved] primary key question

[gunnerj80]

i have a table with a primary key that is set to auto increment. is there any way to get the primary key of the record just added (by doing an "INSERT ...." query) without doing a second query? i am using mysql, by the way.

i know there are ways it can easily be done with a second query, but am looking to find a way it can be done with one.

thanks

[Ravenous]

I don't think you can. INSERTs insert stuff. SELECTs get stuff out. That's it. 🙂

I could be wrong, though.

[dustbuster]

Using mysql_insert_id() you can get the id.

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

[Ravenous]

That's stil ltwo lines of code, but certainly nicer than performing another query. Thanks for that.. I'd never seen mysql_insert_id() before.

[gunnerj80]

thank you, that is just what i was looking for.