RE: [PHP-DB] Re: SELECT
| From: | Toby Hart Dyke | Date: | Mon, 17 Oct 2011 18:20:24 +0000 |
| Subject: | RE: [PHP-DB] Re: SELECT | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-48049@lists.php.net to get a copy of this message | ||
Though the operators are >= and <=, not => and =<.
Toby
-----Original Message-----
From: Jim Giner [mailto:jim.giner@albanyhandball.com]
Sent: Monday, October 17, 2011 1:58 PM
To: php-db@lists.php.net
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)