Calling the database from a view file?

[eluser]TheFuzzy0ne[/eluser]
In your position, I would create function in my model specifically for getting a page of data. I would use an SQL statement to join the tables together, and count the comments into their own column. This would mean that you get to do the business within one query. You'd need to use $this->db->distinct() and $this->db->group_by() to get it the way you want it, and you'd need to use the SQL COUNT() function in the select part of your statement.

Does this help at all?