SitePoint Sponsor

User Tag List

Results 1 to 7 of 7
  1. #1
    SitePoint Enthusiast
    Join Date
    Jul 2002
    Posts
    31
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Random MySQL Errors?

    ?
    Last edited by JungleMan; Nov 3, 2002 at 10:38.

  2. #2
    SitePoint Enthusiast
    Join Date
    Jul 2002
    Posts
    31
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    A hint, anyone?

  3. #3
    SitePoint Enthusiast
    Join Date
    Jul 2002
    Posts
    31
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Bump

  4. #4
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,220
    Mentioned
    58 Post(s)
    Tagged
    3 Thread(s)
    a hint? it's not a mysql problem, it's a php problem

    best i can do, sorry
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  5. #5
    SitePoint Enthusiast
    Join Date
    Jul 2002
    Posts
    31
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hmm, that's good to know, I'll mess with it...anyone have suggestions as to the proper syntax?

  6. #6
    Making a better wheel silver trophy DR_LaRRY_PEpPeR's Avatar
    Join Date
    Jul 2001
    Location
    Missouri
    Posts
    3,428
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    maybe the table could be corrupt or something which is why it works sometimes. you should change your code to this so that you can see the MySQL error:

    PHP Code:
    $result mysql_query("SELECT * FROM review_categories ORDER BY ID") or die(mysql_error()); 
    that will stop your script (when there's an error), but you can see what the error is. if you don't want the script to stop, change the die to print.
    - Matt ** Ignore old signature for now... **
    Dr.BB - Highly optimized to be 2-3x faster than the "Big 3."
    "Do not enclose numeric values in quotes -- that is very non-standard and will only work on MySQL." - MattR

  7. #7
    SitePoint Enthusiast
    Join Date
    Jul 2002
    Posts
    31
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I fixed it by using your solution to debug, thanks...


Bookmarks

Posting Permissions

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