[eluser]xarazar[/eluser]
OK. Just tested Active Records with more functions and this query:
Code:
$q = $this->db->where('parent', 0)->where('visible', 1)->order_by('position', 'desc')->get('content');
works fine whereas this one:
Code:
$this->db->where('parent', 0);
$this->db->where('visible', 1);
$this->db->order_by('position', 'desc');
$q = $this->db->get('content');
fails miserably and returns the entire content of the 'content' table ordered by default.
So it's clear that there problem doesn't lie in the where() clause but in assembling the database query.
Anybody up for a challenge?