Inserting then Selecting the inserted ID

[Anon]

I know I could just do a statement to insert the new entry, then select it. (order by id desc limit 1) But is there any way of doing it with ONE statement?

I am using MySQL.

Any help would be much appreciated,
-Travis

[balsdorf]

If you are using the php mysql functions (not an abstraction layer like pear) you can use mysql_insert_id() to get the last ID. It is not the same query but easy.

Also, using your "order by id desc limit 1" can cause problems. It is possible that another user inserted a record right after you so you would get the wrong ID. Use this query instead "SELECT last_insert_id()". This will return the ID generated from the previous insert statement on your connection

[Anon]

Yeah, that is the exact reason I am trying to get around it.

Thanks for the PHP function, that will do fine.

Again, Thanks.

-Travis