$query->num_rows() - Fatal error: Call to a member function on a non-object

[eluser]m4rw3r[/eluser]
why not add the db result directly to record? The result is the same (the foreach is a waste of cpu and memory, if you don't need to make any changes to the data).

Code:

$query = $this->db->query($sql);

$data['record'] = $query->result_array();

$this->load->view('your_view', $data);

BTW. It is the controller that calls the view, the model only fetches the data.