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();
}
Edit
Report