Does this ever work?

[eluser]jtkendall[/eluser]
In the future please use a more descriptive title.

Is this what you're looking for?

Code:

$this->load->database();
$this->db->where('field', 'value');
$this->db->order_by('field', 'asc');
$result = $this->db->get('table')->result();
foreach($result as $row):
//whatever you want to do here
endforeach;