[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.