Posted by el chupacabra on 12/11/05 22:45

Everytime I want to enter to a textbox area "it's fun" (no quotes) I get an error.

"Problems with 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 's fun'"

I need to enter " it\'s fun" (no quotes) in order for MySql accept it.

Any work arounds on escape characters? How can I have mySQL just take "it's fun" just like that?


--------------= Posted using GrabIt =----------------
------= Binary Usenet downloading made easy =---------
-= Get GrabIt for free from http://www.shemes.com/ =-

• Next in forum: Re: Cannot use "-" in variable names?
• Prev in forum: Re: Database & DB Size Question
• Thread view: php and mysql escape characters

[Reply to this message]