how to calculate the difference in date with mysql curdate code example
Example: mysql curdate between two dates
SELECT * FROM `table` WHERE active=0 AND CURDATE() between dateStart and dateEnd
SELECT * FROM `table` WHERE active=0 AND CURDATE() between dateStart and dateEnd