WHERE date > DATE_SUB(NOW(), INTERVAL 1 MONTH) Need an END DATE suggestion please

[0o0o0]

I have this below ive used it for a couple years..

$query = "SELECT * FROM `table` WHERE date > DATE_SUB(NOW(), INTERVAL 1 
MONTH)  ORDER BY Date DESC";

Works great .. but I would like to add an ending date to it..   i've tried the below way and it works ...but I like how the above would dwindle down slowly to showing less and less information by the following month or set date.. 

$query = "SELECT * FROM `table` WHERE date BETWEEN '2015-06-19' AND '2015-08-01' 
ORDER BY Date DESC";

Need something added to WHERE date > DATE_SUB(NOW(), INTERVAL 1 MONTH) (example stop showing anything after '2015-08-01' or set future date.)

 

so the viewer slowly stops seeing june 19 tomorrow.. june 20 next day.. less and less... that by September 1st the user has to contact me by phone or email because they have nothing left to see.

Thanks

Edited July 19, 2015 by 0o0o0

[Ch0cu3r]

Try

$query = "SELECT * FROM `table` WHERE date > DATE_SUB(NOW(), INTERVAL 1 MONTH) AND date < '2015-08-01' 
ORDER BY Date DESC";

[0o0o0]

oh and date LESS than. Thank you sir!