Display single record in view

[eluser]Atharva[/eluser]
In model (some_model.php)

Code:

function blah($id)
{
   $sql = 'SELECT * FROM TABLE WHERE ID=? LIMIT 1';
   $query = $this->db->query($sql,array($id));
   return ($query->num_rows() > 0) ? $query->row() : false;
}

In controller

Code:

$this->load->model('some_model');
$data['details'] = $this->some_model->blah($id);
$this->load->view('some_view',$data);

In View (some_view.php) assuming query is returning a non empty record

Code:

echo $details->field_from_db;
echo $details->another_field_from_db;