second query based on first query

[eluser]vitoco[/eluser]
Just FYI , the idea of MVC it's to separate the data retrieving ( logic ) from their presentation, so it's good that you run the database queries inside the model, but not to create the html code( a table in this case ) in the same function, just retrieve the data to the controller, and then pass that data to the view.

In the long run ( not so long really ) it will be a mess if you combine both in the same code.