Hi... I am brand new to CI and I've been going through the "news" tutorial. I am adding onto it with "articles" (copy of the "news" section) and I wanted to have a list of article categories. Everything is going great, but when I got to my list of categories... well, I would like to print out how many articles in each category, but I have something wrong and I'm not sure what.
<code>
<ul>
<?php
$this->db->select('*, count(*)');
$this->db->from('article_cats');
$this->db->join('articles', 'articles.cat_id = article_cats.cat_id');
$this->db->group_by('article_cats.cat_id');
$query = $this->db->get();
$articlecount = $query->num_rows();
foreach ($query->result() as $row) {
print '<li>'.$articlecount.' <a href="'.ARTICLES.'/'.$row->cat_slug.'" title="'.$row->cat_title.'">'.$row->cat_title.'</a></li>';
}
?>
</ul>
</code>
and this returns:
- 3 Misc Articles
- 3 Acne Articles
- 3 Allergy Articles
"3" being all 3 articles currently in the database
Any and all help is greatly appreciated! Thanks!
