PHP&MySQL: Is it possible after running mysql_query with an insert to get the ID of the new row?

Question

Is there a straightforward way to run mysql_query with an insert and get the ID of the new row, for example in the return? Or will I have to do another query with select to check it?

score 7 · Accepted Answer · answered Mar 03 '09 at 19:51

7

mysql_insert_id()

or

select last_insert_id()

answered Mar 03 '09 at 19:51

score 2 · Answer 2 · answered Mar 03 '09 at 19:51

2

Simply call mysql_insert_id after running mysql_query and you will get the ID.

answered Mar 03 '09 at 19:51

Noah Goodrich

24,875
14
66
96

score 2 · Answer 3 · answered Mar 03 '09 at 19:52

2

Try mysql_insert _id()

answered Mar 03 '09 at 19:52

soulmerge

73,842
19
118
155

PHP&MySQL: Is it possible after running mysql_query with an insert to get the ID of the new row?

3 Answers3