+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forum-20.html)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forum-23.html)
+--- Thread: Need Help with Count... (/thread-36369.html)
Need Help with Count... - El Forum - 11-29-2010
[eluser]HSKrustofsky[/eluser]
I would like to display the number of comments that have been posted within each link on my site. For example, my site displays a list of videos and a person selects a video, they are then redirected to the page displaying the video where there they can then comment. In the initial list I would like to display the number of comments for each video. The code below is what I got, but all that is being displayed is the number of comments for the first video on every video on the list.
Model:
Code:
function getCount() {
$this->db->select('videos.*, count(comments.entry_id) as num_comments');
$this->db->from('videos');
$this->db->join('comments', 'comments.entry_id = videos.id');
$this->db->group_by('videos.id');
$query = $this->db->get();
return $query->row();
}Controller:
Code:
function index() {
$this->load->model('videos_model');
$data['count'] = $this->videos_model->getCount();
$this->load->view('videos', $data);
}View:
Code:
...
<div class="totalComments">Comments: <?php echo $count->num_comments; ?></div>
...What should I do?