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

[eluser]bradym[/eluser]
1 - Get the id of the current category
2 - Get the children of the current category

I always have a parent field in category tables, so it would be a simple query:

Code:

$this->db->query("SELECT name FROM category WHERE parent = $category_id");

You could easily combine both steps into one function in your model.