Opinion on best coding practices

[eluser]stuffradio[/eluser]
Have a model with

Code:

$lines = $this->db->query("select * from tasklist where (Active=1 or Priority=1)");
return $lines->result();

- pass the array in your controller from the model to the view
- do a foreach loop and echo the table

Edit: Exactly what he said is what I did here.