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?
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.