Mysql error in php code

Question

Hello, can't understand mysql error:

UPDATE static_pages SET order = " Some new data 222222

"Database 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 'order = "

$query = 'UPDATE someTable SET '.$key.' = "'.$value.'"';

Here is $key = order; $value = 'new data 222222'; There is such keys in table: order, prices, contacts. Each of these updates well except the 'order'. Why?

Answer 1

ORDER is a reserved word.

Use back ticks to escape the column name:

UPDATE static_pages SET `order` = ";

Don't forget the WHERE clause so that you can update only specific records.

UPDATE static_pages SET `order` = "
WHERE id = 12;

Answer 2

Where is WHERE

Have to use WHERE clause with update buddy

Answer 3

order is a keyword in SQL. protect it with quotes in your query.

Best option is to rename your 'order' field

If you can't, here's a possible solution:

$query = 'UPDATE someTable SET `'.$key.'` = "'.$value.'"';

Answer 4

use `around the key`

$query = "UPDATE `someTable` SET `$key` = '$value'";

Answer 5

You can encase the reserved word orders into backticks '`' or rename the field.