On Mon, Oct 17, 2011 at 12:58 PM, Jim Giner
<jim.gi...@albanyhandball.com> wrote:
> 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)

Hmm, no this won't work. Check this:

start_month=10
start_day=15

end_month=1
end_day=1

sel_day=23
sel_month=12

in this case, sel_month IS greater than start_month and  sel_day IS
greater than start_day, HOWEVER sel_month is ALSO greater than
end_month and sel_day is ALSO greater than end_day in this case.

(wrap around to new year problem, wrap around to new month problem)

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to