I would do it this way: Where $sel_d = (the day # you want) $sel_m = (the month # you want) The "where" clause would be: Where (start_month => $sel_m and start_day => $sel_d) and (end_month =< $sel_m and end_day =< $sel_d) Someone else will probably have something more elegant, but I believe this will work for you. Never used the between clause before - have to remember that. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php