Generate Table From Query ( Where? )

[eluser]Unknown[/eluser]
This code to generate a table from a query. where do i put it in the MVC ?

Code:

echo $this->table->generate($query);

in the model i got this right now

Code:

$this->db->select('*')->from('posts');
$query = $this->db->get();
return $query->result();

Thanks! Notflip -novice

[eluser]Future Webs[/eluser]
you do the database work in the model
assign the query in the controller and pass to the view
display the table using the echo statement in your view