Codeigniter:Retrieve single row from database

gistfile1.txt

//Setup a database connection returning a single row value
$this->db->select("*");
$this->db->where("field", $value);
$query = $this->db->get("table",1,0);

if($query->num_rows() > 0) {
    $variable = $query->row("field");
    return $variable;    
} else {
    return FALSE;
}