Calling the database from a view file?

[eluser]timsby[/eluser]
Sorry but not really i'm a little more confused now, how would i develop this into a model to use on a more regular basis bearing in mind the above code is located inside a blog entries foreach loop, it gets the row id of the entry and uses it to count how many corresponding comments there relating to that row id inside the comments table.

Code:

<?php foreach($query->result() as $row): ?>

<?php
    $this->db->where('entry_id', $row->id);
    $comments_num = $this->db->count_all_results('comments');
?>

<h3>&lt;?=$row->title?&gt;</h3>
<p>&lt;?=$row->body?&gt;</p>

<p>&lt;?=anchor('blog/comments/'.$row->id, 'Comments ('.$comments_num.')');?&gt;</p>

<hr>

&lt;?php endforeach; ?&gt;