Display single record in view

[eluser]Twisted1919[/eluser]

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;
}