possible DB glitch in 1.7

[eluser]ray73864[/eluser]
for the 'from' and 'join' clause, just drop the 'AS', not even MySQL requires it to be there, you can just do:

Code:

$this->CI->db->from('pages a')

and

Code:

$this->CI->db->join('pages b','a.parent_id=b.page_id','left')

.

that might be all that you have to change to get it to work again.