Using ' and " in mediumtext

[Anon]

I have a script that stores data users fill out with a form in a mysql database. For the text part of it, I use a a variable of type mediumtext. I've noticed when I use ' and " and some other characters inside the text, the script screws up.

How can I save those text messages into a mysql database?

[yelvington]

You "escape" them with backslashes. That is why PHP has the magic_quotes_gpc setting and functions that allow you to do add/remove slashes explicitly.

http://www.mysql.com/doc/S/t/String_syntax.html