MySQL doesnt like fields with single quotes in them?

' is causing me problems

[will1480]

I am having trouble addiny a row to my shopping cart when a field has a single quote, ' , in it. There might be other characters causing problems as well. Has anyone had these problems before and give me some insight? I am using varchar for those fields

[willybfriendly]

You need to escape the single quotes. Try mysql_escape() if you are using PHP.

WBF

[jatar_k]

mysql_escape_string() [ca.php.net]