MySQL Multiple table association insert data about the problem, please master help, dead ...

MySQL Multi-table association to insert data problems, please master help, anxious to die ...
I insert a piece of data in table A, where the ID field is autogrow, then I use mysql_insert_id (), get the ID of the data just inserted, and then insert a few data into table B with a For loop, and the ID of Table B is just the mysql_insert_id (); Obtained, the program has just started the internal testing of the company has appeared, the staff of the Insert B table of data ID how to become an employee ID, chaos, please help out an idea, how to solve this problem, to a table ID and B table ID is the same, thank you ...

------Solution--------------------
This problem may occur when concurrency occurs, please use transaction, if you do not support transaction, use the lock

