[eluser]fourcs[/eluser]
My select statement in the model did that.
Then the sql statement went on to handle possible fields for searching with the following:
Code:
function records_getall()
{
$this->load->database();
$this->db->select("
records.category,
records.beds,
records.normal_Price,
records.dt_start,
records.dt_end,
records.sb_Price"
);
$this->db->or_like('dt_start','match');
$this->db->or_like('dt_end','match');
$this->db->or_like('category','match');
$this->db->or_like('beds','match');
$this->db->or_like('sb_Price_Range','match');
$this->db->from('records');
$query = $this->db->get();
return $query->result();
}
and is supposed to search the table for matched input field values.