Menu from mysql in view

[eluser]LuckyFella73[/eluser]
I would place the db query in a model for its a cleaner solution.
If you need the menu data in several controllers you will have to
repeat the code again and again.

If you place the db query in a model you can also set up a method
formatting the db result with needed html/ css and return the whole
html menu part (and send that to your view).
In case you have to change the html of your menu you have everything in one place.

Having the query in your view files would force you to edit up to maaany
lines in case something changes.