New to CI and need help |
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:
Any and all help is greatly appreciated! Thanks!
use count(*) as article_count, then output $row->article_count
query->num_rows is the total number of rows in your query not the article count.
Simpler is always better
|
Welcome Guest, Not a member yet? Register Sign In |