Calling the database from a view file?

[eluser]kgill[/eluser]
You're over-thinking this... Instead of returning the query object from your model, return the data you actually need either as an array or an object. This means you process the result object in your model and then you're free to do what you need to do such as your looping through the results and running a 2nd query to add in the number of comments.

However, the simpler solution would be to select what you want from the start, join the two tables (blog posts & comments) and select the posts + a count of comments grouped by the blog posts in your model.