Check if the current date is between two dates + mysql select query

Try this :: This will solve your problem

SELECT * FROM `table` WHERE active=0 AND CURDATE() between dateStart and dateEnd

MySQL uses YYYY-MM-DD by default:

$todaysDate="2012-26-11";

should be:

$todaysDate="2012-11-26";

And you need single quotes around it in the query.