Removing Quotations from Submitted Forms

[leachus2002]

Hi There,

 

I am putting a form together that when submitted, pumps data in to an SQL DB. However I am having problems with quotation marks - for example, it's and her's and thier's cause an error, because the insert statement takes the quote as the end of the row.

 

How can PHP handle this so that it either removes, or replaces that quote?

 

Thanks

Matt

[trq]

All user inputted data needs to be escaped using mysql_real_escape_string before it is used in any queries.