retreiving the latest record

[learnvb1]

You would be preforming the query of the second user so no. However, what you might be do is store your search for use later on.

i only have to use that ID only once...but my confusion is that by mistake (taking the last inserted data in the database ) can the query return the ID which was inserted by another user

example

id =1 is inserted by me and at the same time id =2 was inserted by another user

when i use the mysql_insert_id function ...will it return ID =1 or ID =2 ?