This isn't usually the case in a web environment, unless you are using a persistent mysql connection across multiple instances of the same script.
mysql_insert_id() returns the last insert id for your current mysql connection, and if each execution of the script uses a different mysql connection then what you mentioned will not be a problem.
Hope this helps. Toro
Binay wrote:
Hi
I have a php script which insert a row in one of my table. Now i want the auto_generated id produced by this insert query. I know i can use mysql_insert_id function to fetch that auto_generated id. But my question is say two or more person visiting the same page/script causes a insert operation in the table at the same time. so there are chances of getting wrong auto_generated ids for different visitors. why am i saying this can be clear from below example.
Say one insert operation is in the progress and by the time control switches/call to mysql_insert_id function another insert operation starts .. so ultimately mysql_insert_id will fetch 2nd insert operation id which should not be the case. How to resolve this case??
Thanks
Binay
#####################################################################################
This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal
For more information please visit www.marshalsoftware.com
#####################################################################################
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
