> $month_start : starting month > $month_end : ending month > > $day_start : starting day > $day_end : ending day
You could add something like this in the WHERE clause: ((MONTH(closing) >= $month_start AND DAY(closing) >= $day_start) AND (MONTH(closing) <= $month_end AND DAY(closing) <= $day_end)) -- Atte, Andrés G. Montañez Técnico en Redes y Telecomunicaciones Montevideo - Uruguay -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
