Showing number of comments in blog (while listing all posts)

[eluser]sl3dg3hamm3r[/eluser]
untested:

Code:

$this->db->select("blog.blog_id, blog.blog_author, blog.blog_insert_date, count(*) AS 'total_comment'");
$this->db->join('comment', ' blog.blog_id = comment.blog_id', 'LEFT');
$this->db->group_by('blog.blog_id, blog.blog_author, blog.blog_insert_date');
$query = $this->db->get('blog');