Re: SELECT

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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. 



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



[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux