using BETWEEN in WHERE condition

Question

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- gt db- gt limit  limit   pgoffset            this- gt db- gt order by  id    desc             this- gt db- gt where  state id   state id            this- gt db- gt where  city   city               This one should become a between selector          this- gt db- gt where  accommodation  minvalue              result hotels    this- gt db- gt get  hotels            return  result hotels- gt result

User · Answer

You might also encounter an error message. "Operand type clash: date is incompatible with int.

Use single quotes around the dates. E.g.: $this->db->where("$accommodation BETWEEN '$minvalue' AND '$maxvalue'");

User · Answer

this- gt db- gt where  accommodation BETWEEN       sdate      AND       edate         this is my solution

User · Answer

Sounds correct but some issues maybe creates executing  this query   I would suggest     this- gt db- gt where    accommodation BETWEEN  minvalue AND  maxvalue   NULL  FALSE

User · Answer

I think we can write like this    this- db- where  accommodation      minvalue    this- db- where  accommodation  lt     maxvalue      without dollar    sign It s work for me

User · Answer

In Codeigniter This is simple Way to check between two date records        start date  2016-01-01    end date  2016-01-31     this- gt db- gt where  date BETWEEN     date  Y-m-d   strtotime  start date       and     date  Y-m-d   strtotime  end date

User · Answer

You should use   this- gt db- gt where   accommodation  gt     minvalue    this- gt db- gt where   accommodation  lt     maxvalue     I m not sure of syntax  so I beg your pardon if it s not correct  Anyway BETWEEN is implemented using   min  amp  amp   lt  max  This is the meaning of my example   EDITED  Looking at this link I think you could write    this- gt db- gt where   accommodation BETWEEN  minvalue AND  maxvalue

[php] using BETWEEN in WHERE condition

Examples related to php

Examples related to codeigniter