Forced to run DB Query from View (Bad practice?)

[eluser]Pascal Kriete[/eluser]
The current logic doesn't, but I believe that's what the PS was for.

If all you have are categories and entries with no further nesting, then all you have to do is join the two tables. Truly one query.

Code:

$this->db->join('entries', 'entries.FK_category_id = 'categories.category_id', 'left');