character '

[Anon]

well i've made a form and when i type something with an ' in it like "it's" then i get an error like this:
You have an error in your SQL syntax near 's a shiny day at line 2

the colum type is text

hope you have an idea thanks

[[deleted]]

try using addslashes() to escape the quote, change it into something that SQL understands.