Operator precedence in SQL queries using DB class

[eluser]dmiden[/eluser]
Hi!

You should use the $this->db->query() function for more complexed queries, f.ex.

Code:

$sql = "SELECT * FROM table WHERE date = ? AND (id = ? OR other_id = ?)";
$this->db->query($sql, array($date, $id, $id));

Or you could use $this->db->where() as a custom string, e.g.

Code:

$this->db->where('date', $date);
$this->db->where("(id={$id} OR other_id={$id})");
$this->db->get('table');

That'd produce the same as above.