Though the operators are >= and <=, not => and =<. Toby
-----Original Message----- From: Jim Giner [mailto:[email protected]] Sent: Monday, October 17, 2011 1:58 PM To: [email protected] Subject: [PHP-DB] 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
