do apostrophes ( ' ) mess up querys mysql

[marcusami]

i have a form that i am handling with php and storing
in a mysql database. it works but if i use an apostrophe
i get an error any ideas?

regards
Marcus

[marcusami]

never mind yes it does mess it up and u use mysql_real_escape_string to remedy it

$theText = mysql_real_escape_string($theText);

[felgall]

That is what mysql_real_escape_string is for. If it were not for those characters such as apostrophes that have a special meaning in mySQL then that function would not exist.