Tuesday, 3 September 2013

mySQL insert syntax error with quote

mySQL insert syntax error with quote

I'm receive the following error below, I believe its do in part the quote
that I have in the insert string 5'10 - (178cm) in which is passed by the
$en['height'] variable. what's the best way to handle this error?
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
'10 - (178cm)', m_btype = 'Rather Not Say' at line 12
this is the mysql insert:
m_height = '".$en['height']."',
table is set as:
varchar(30) latin1_swedish_ci

No comments:

Post a Comment