CodeIgniter / MVC best practices

[eluser]xwero[/eluser]
If the same data isn't requested elsewhere i put the formating in the query but this means i loose the flexibility to go to another database as the functions are mostly database specific.

I don't see the use of formating the data in the controller to loop it again in the view. if data needs formating use functions in the view. if the formating requires multiple functions or parameters that can be set globally wrap them to keep the php code as short as possible.