I am getting Error Number: 1064 while updatin data into mysql,

Question

I am using codeigniter and i just want update a single value in database using following query;

$this->db->query('UPDATE order SET status="1" WHERE orderid="$id";');

but i getting following error.

Error Number: 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 'order SET status="1" WHERE orderid="$id"' at line 1

UPDATE order SET status="1" WHERE orderid="$id";

Filename: C:\xampp\htdocs\oshop\system\database\DB_driver.php

Line Number: 330

`$this->db->query("UPDATE order SET status=1 WHERE orderid='$id'");` — John Conde, Apr 23 '15 at 18:43

score 2 · Accepted Answer · answered Apr 23 '15 at 18:44

2

order is a reserved word, therefore it must be quoted:

$this->db->query('UPDATE `order` SET status="1" WHERE orderid="$id";');
                         ^-----^

Relevant doc: http://dev.mysql.com/doc/refman/5.6/en/reserved-words.html

answered Apr 23 '15 at 18:44

Marc B

356,200
43
426
500

I am getting Error Number: 1064 while updatin data into mysql,

1 Answers1