Welcome Guest, Not a member yet? Register   Sign In
New to CI and need help
#1

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.'&nbsp; <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!
Reply
#2

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
Reply
#3

(07-31-2018, 09:44 AM)donpwinston Wrote: 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.

Thank you so very much!
Reply




Theme © iAndrew 2016 - Forum software by © MyBB