Zend DB using a column for both Where and Order clause

Question

I like to use a column in Zend both in the Where clause as well as the Order:

$select = $this->select();
$select = $select->where('year = ?', $year)
                 ->where('order != ?', 0)
                 ->order('order');
$rows = $this->fetchAll($select);

But when I do this, I get the following error:

SQLSTATE[42000]: Syntax error or access violation: 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 != 0) ORDER BY order ASC' at line 1

Why??!

When you remove the ->order()-call, does it work?

Patrick B.
– Patrick B.

2013-02-28 22:34:44 +00:00
Commented Feb 28, 2013 at 22:34 — Patrick B.
– Patrick B., Commented Feb 28, 2013 at 22:34

Fabian Barney · Accepted Answer · 2013-02-28 22:34:44Z

3

You must put the column name order into ticks since it is a reserved word of SQL syntax. Even better never name your columns like keywords in SQL, so rename your column order to something else.

answered Feb 28, 2013 at 22:34

Fabian Barney

14.6k6 gold badges45 silver badges63 bronze badges

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

Collectives™ on Stack Overflow

Zend DB using a column for both Where and Order clause

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related