Converting an app to CI (conceptualizing the breakdown)

[eluser]Mirage[/eluser]
Well, from an MVC point of view you have a few things in the wrong place. While CI allows it, your view file has way too much business logic in it.

Try this:

1. From the controller call your Model to fetch the menu structure
2. In the Model, run all the queries you need to build up the menu and 'model' the complete result e.g. into a nested array or similar. Return that completed structure to the controller.
3. From the controller pass this menu structure to the view.
4. In the view unroll the data in a loop/nested loop.

The model is where it all happens. The controller is just a traffic cop and the view just a [dumb] presentation of your data.

Cheers!