Problems with using ' in tinymce (PHP/MYSQL)

Hi All

Ok I’m not sure where this should go however I’m having a slight problem with a form that I have created. The form uses tiny mce, and the problem I’m having is that when I use ’ symbols inside the form I get an error message from the MYSQL server saying I can’t type these symbols. ’

If I use the special character link inside the tinymce it does work, however, you don’t have to do that on some systems such as this one or wordpress. can any one help?

Use a *_real_esacpe_string function, like mysql_real_escape_string(), before putting the form’s value into a query.