CodeIgniter best practice for accessing multiple tables in single view
I'm building a proof of concept application which like many db applications will need at times to pull in data from multiple tables and display them in a single view.
So, my question is this - what's best practice?
Obviously, CodeIgniter is an MVC framework, so what jumps to mind is that each table should have its own model, regardless of what I do with them later.
Then I'd load the models for the tables I want in the controller, and then the view will read from those different arrays of data.
Would this be best practice?