Check Available Rooms For Selected Dates

You can check the available rooms with a subquery.

PHP Code:

$this->db
->select('room_no')
->from('reservation')
->where('days >=', $date_in)
->where('days <=', $date_out);
$where_clause = $this->db->get_compiled_select();

$query = $this->db->where("room_id NOT IN ($where_clause)", NULL, FALSE)->get('rooms');
if ($query->num_rows() == 0) {
   return FALSE;
}
else {
   return $query->result();
}