Hi,

Can anyone help with understanding operator precedence with Zend_Db_Select;

The query I want to execute is

SELECT * FROM myTable WHERE a = 1 AND (b = 0 OR c = 0 OR d = 0);

I've tried a few combinations of:

$sql = $this->_db->select();
$sql->from('myTable', *);
$sql->where('a = ?', 1);
$sql->orwhere('b = ?', 0);
$sql->orWhere('c = ?', 0);
$sql->orwhere('d = ?', 0);

$sql = $this->_db->select();
$sql->from('myTable', *);
$sql->orwhere('b = ?', 0);
$sql->orWhere('c = ?', 0);
$sql->orwhere('d = ?', 0);
$sql->where('a = ?', 1);

etc...

But I can't get it right.

Thanks

Andrew

DB Select Manual

Example 9.53 looks like just what you want.

That's perfect, it's also embarrassingly directly below the section which I used to work out how to do OR.

Thanks again,

Andrew