PHP: date between date

Question

I have two dates:

10-11-2010 and 17-11-2010

Now i would like to SELECT all rows with the dates between those two.

How can I do that?

Are you wanting to select from a database? If so, some table structure information might be useful — Mark Baker
– Mark Baker, Commented Nov 17, 2010 at 9:52

Haim Evgi · Accepted Answer · 2010-11-17 09:51:57Z

10

its very simple using between in where clause , read more

select * from mytable where date between '10-11-2010' and '17-11-2010'

answered Nov 17, 2010 at 9:51

Haim Evgi

126k46 gold badges222 silver badges227 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Martin · Accepted Answer · 2010-11-17 09:52:52Z

2

Sounds like a SQL question. Try the between condition.

answered Nov 17, 2010 at 9:52

Martin

7194 silver badges11 bronze badges

karan · Accepted Answer · 2018-01-25 12:36:57Z

1

$datefrom=date('Y-m-d'); $dateto=date('Y-m-d');

$sql = 'select * from mytable where depositdate between $datefrom and $dateto';

answered Jan 25, 2018 at 12:36

karan

111 bronze badge