Select as with non unique results

[eluser]danmontgomery[/eluser]
Just to explain this (even though you found a different solution), even though you are differentiating between tables for the "name" column, the table name isn't included in the result, so you were getting back 2 "name" columns, and PHP doesn't handle non-unique array keys. The simple solution would be to just assign aliases for the result columns:

Code:

$this->db->select('p.id AS p_id, l.id AS l_id, p.active, p.name AS p_name, l.name AS l_name');