1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

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,646
    Likes Received:
    86
    Trophy Points:
    0
    Occupation:
    Programmer
    Location:
    Kolkata, India
    Home Page:
    Use the addslashes function to escape the ' present in the input.
     

Share This Page