Calling the database from a view file?

[eluser]obiron2[/eluser]
OK,

Before you got to your view, you must have built and array of posts.

1st improvement:
In the view you are looping through the posts array and fetching the number of comments back as a query. You could do this just as easily in the controller and add a new element to each posts array/object which is the number of comments and then use that in your view. This has 2 benefits. The person maintaining the view doesn't have to know anything about the database structure and the view should render faster as the data is pre-fetched.

2nd improvement:
There is a direct relationship between the post and the number of comments so you could get the number of comments while you are getting the blog posts with a simple join and return the count of the posts as part of the data array. This requires less trips to the database and could be significantly faster. IF you wanted to show the comments as well, this is a different issue as there will be n comments for each post and you need a nested array.

obiron