Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2006
    Posts
    1

    Unanswered: How to handle Simultaneous updates

    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

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    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
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •