last inserted row in mysql

Question

I executed a query which will insert an image link and username into a table:

INSERT into pictures set src = 'image link', username = 'acc'

I want to display that image after the query is executed (from table), or to get ID (I tried mysql_insert_id(), but what if 3 or more users will execute the query at the same time, which id will I get?

Thanks.

Answer 1

It gets the last ID from your database session, so if other users insert, that does not matter :D.

As long as your session does not do other insert (thats quite unlikely in mosts systems) in between you're fine