Though the operators are >= and <=, not => and =<. Toby -----Original Message----- From: Jim Giner [mailto:jim.giner@xxxxxxxxxxxxxxxxxx] Sent: Monday, October 17, 2011 1:58 PM To: php-db@xxxxxxxxxxxxx Subject: Re: SELECT 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) -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php