Form Error When User Enters "'"

I have a form on my site, which works fine but if the user enters an inverted comma in the field I get the following error on the formInsert.php page...

Warning: mysql_close(): supplied argument is not a valid MySQL-Link resource in /home/formInsert.php on line 314
Failed to insert: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 't st!','1', '1', '1', '1', '1' at line 1

I think the "'" is getting posted and closing off the data, and adding extra so "couldn't" is getting entered as "couldn" "'t" anyway around this...

This is what get's posted on the insert page...

$q10 = stripslashes($_POST['q10']);

Are you using mysql_real_escape_string in the data? Its the same thing I told you already except you never responded which you seem to do quite often. You ask a question, get answers but don't return to your question.

I see... I will look at the response and answer... Apologies.

And yet you still didn't answer him... Are you using mysql_real_escape_string in the data?

Yes I looked at the other response and answered that.