Gathering data BASED on already gathered data?

[eluser]tonanbarbarian[/eluser]
2 main ways to do this

the way i do not like doing (too many queries) is that in the foreach loop that displays the todo lists you run a query - one for each list, that finds the associated entires.
and of course i prefer to do this in the controller rather than the view

the other way that i prefer is to write your original query to join the tables and retrieve all of the data in one go
then when you loop through the data you detect the change of list and display accordingly