Incorrect query: You have an error in your SQL syntax; check the manual that correspo

Discussion in 'PHP' started by jackparsons, Aug 20, 2008.

  1. jackparsons

    jackparsons New Member

    Joined:
    Aug 20, 2008
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    0
    Hi All

    I have a search engine. When I type in ' i get this error

    Incorrect query:
    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 ''''' at line 1
    [STOPED]

    Can anyone help me fix this, in return i will give you a copy of the search engine for free

    Email me at jackparsons2@yahoo.com

    Jack
     
  2. franc14529

    franc14529 New Member

    Joined:
    Aug 17, 2008
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    0

    hi i work with plsql oracle and tsql sql server.why you dont just post the querry causing the error so i can fix it and help you by the way

    best regards
    francois saab
     
  3. pradeep

    pradeep Team Leader

    Joined:
    Apr 4, 2005
    Messages:
    1,645
    Likes Received:
    87
    Trophy Points:
    0
    Occupation:
    Programmer
    Location:
    Kolkata, India
    Home Page:
    http://blog.pradeep.net.in
    Use the addslashes function to escape the ' present in the input.
     

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice