更新mysql错误1064 [关闭]

Question

i have that query

$upaddr = "
         UPDATE `ec_address` SET  
        `Dist_Name` = '$_POST[dist_name]',
        `Address` = '$_POST[address]',
        `Number` = '$_POST[number]',
        `Floor` = '$_POST[floor]',
        `Bell_Name` = '$_POST[bell_name]',
        `Area` = '$_POST[area]',
        `Tel` = '$_POST[tel]',
        `Map` = '$_POST[map]',
        'Descr' = '$_POST[desc]'

         WHERE `Address_ID`= 14 ";

and that error appears: #1064 - 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 ''ec_address' SET 'Dist_Name' at line 1

can you help me?

Answer 1

System words such as tables and columns must be encased in backticks:

UPDATE `ec_address` 
    SET `column` = 'value'
    ...
WHERE `Address_ID` = 14

You also need to look into sanitizing your input. You're completely open to SQL injection. Learn about prepared statements.