KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I'd like the following function to select hotels with an accomodation between a certain $minvalue and $maxvalue . What would be the best way to do that? function gethotels($state_id,$city,$accommodation,$minvalue,$maxvalue,$limit,$pgoffset) { $this->db->limit($limit, $pgoffset); $this->db->order_by("id", "desc"); $this->db->where('state_id',$state_id); $this->db->where('city',$city); // This one should become a between selector $this->db->where($accommodation,$minvalue); $result_hotels = $this->db->get('hotels'); return $result_hotels->result(); }
Tags (comma-separated)
Save Edits
Cancel