Re: SELECT
| From: | Jim Giner | Date: | Mon, 17 Oct 2011 17:58:11 +0000 |
| Subject: | Re: SELECT | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-48048@lists.php.net to get a copy of this message | ||
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.