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
