Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2002
    Location
    Australia
    Posts
    455

    MySQL Error? Maybe?

    My browser based game uses a MySQL DB backend and I have a suspecion that because of so many DB queries at one time, that it is mixing up varibles. Does anyone know if this would be the case and how to stop it.

    Thanks.
    - Andy
    Free browser based game:
    http://www.critticage.com
    Play in your spare time!

  2. #2
    Join Date
    Nov 2000
    Posts
    3,042
    Depending on what you meant I have two things to say:

    If you mean it does a lot of seperate mysql queries (for example in PHP):

    mysql_query("SELECT blah FROM foo");
    mysql_query("SELECT foo FROM blah");

    each instance of the query would run seperately, obviously since PHP parses line by line. If you mean one query that is fairly complex, it's still the same issue. No matter how complex mysql can handle it, and if the syntax of the query is messed up you get a (duh!) syntax error.

    So what it all boils down to is, it's either your programming code (PHP, Perl etc), like you accidently misplaced a variable or something like that. Or you are using the wrong value for your tables or something like that.

    To make my long story short (now I make it short ) there is no way for a programming language to assign incorrect variables simply because you are using a lot of DB queries.
    A well-reasoned assumption is very close to fact.
    - Adorno

  3. #3
    Join Date
    Nov 2000
    Posts
    3,042
    BTW: I like the game .
    A well-reasoned assumption is very close to fact.
    - Adorno

  4. #4
    Join Date
    Jun 2002
    Location
    Australia
    Posts
    455
    I thought MySQL might be able to mix up queries like what can happen with txt files? Guess not.

    Thanks, about the comment about the game, and thanks for the help.
    - Andy
    Free browser based game:
    http://www.critticage.com
    Play in your spare time!

Posting Permissions

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