MySQL error when i add apostraphe in form
When I add a apostraphe into a form that saves to a MySQL database i get
the below error
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 'We are one of
the UKs leading suppliers of hotel toiletries and ame' at line 1
Here is my code:
$result = mysql_query("UPDATE admin SET aboutcontent='$aboutcontent',
abouttitle='$abouttitle', aboutside='$aboutside',
aboutsidetitle='$aboutsidetitle'")
Is there a way round this?
No comments:
Post a Comment