MYSQL Syntax Error in DB Query

Question

I have the following error but I cant find the issue - can anyone else spot it - need another set of eyes:

Error near 'order, state) VALUES ('SAME',2,'1',10,1)'

DB Query:

    $query = "INSERT INTO $table (brand_name, brand_id, cat_id, order, state) VALUES (?,?,?,?,?)";
    $this->db->query($query, array($brand_name, $brand_id, $cat, $order ,$state));

Wow, that's weird! I can't see the error. Whats the value of $table? — Vitor Villar
– Vitor Villar, Commented Sep 22, 2013 at 3:21

Christophe Biocca · Accepted Answer · 2013-09-22 03:27:48Z

4

Order is a reserved keyword, you need to wrap it in backticks or double quotes (depending on your database config): `order` or "order".

edited Sep 22, 2013 at 3:27

answered Sep 22, 2013 at 3:21

Christophe Biocca

3,4681 gold badge25 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Angel · Accepted Answer · 2013-09-22 04:06:49Z

0

add quotations '' around variables

answered Sep 22, 2013 at 4:06

Angel

1463 silver badges11 bronze badges

Collectives™ on Stack Overflow

MYSQL Syntax Error in DB Query

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related