[solved] Comment Counting Again

[eluser]darkhouse[/eluser]
change your get_entries sql to this:

Code:

function getEntries()
{
    $this->db->select('e.*, COUNT(c.entry_ID) AS total_comments');
    $this->db->join('comments c', 'c.entry_ID = e.id');
    $this->db->group_by('c.entry_ID');
    $query['entries'] = $this->db->get('entries e');    
    return $query;
}

you should now have a new property in your row object called total_comments which should be the count of all comments for each blog entry.