The problem which i am facing is that I have a table which is accessed by 50 users. whenerver user sends a query an ID is assign to him, and the flag of that ID is set to 1 that means it is occupied but when two user sends the query simultaneously then the same ID is assign to both which shouldn't happen.

and My table type is MyISAM

Please Help Me.

Thnax in Advance

you may want to ask that this question be moved to the forum for whatever language you;re using

mysql is not the problem here, it is your script