Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    New to the CF scene
    Join Date
    Feb 2004
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    mysql syntax error

    You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE uid='13'' at line 1

    this is the error i get. what does it mean, how do i remove it? :|

  • #2
    raf
    raf is offline
    Master Coder
    Join Date
    Jul 2002
    Posts
    6,589
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: mysql syntax error

    Originally posted by luke xx
    You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE uid='13'' at line 1

    this is the error i get. what does it mean, how do i remove it? :|
    Welcome here!

    It means that you have a error in your sql-syntax right before the where clause. If you need more helpfull comments, then you need to give us a bit more info, like for instance the sql-statement

    Or add this right after the line with your sql_statement.
    die ($select);

    (assuming that $select is your sql-statement. So your code would then look like
    $select="select ... where uid=13";
    die ($select);

    And then reload the page in your browser and look at the printed sql-statement (or post it here)

    Note: uid isprobably a numerical column, so you don't need to enclose the values for it in quotes.


  •  

    Posting Permissions

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