RE: [PHP] Date problem
| From: | John W. Holmes | Date: | Tue, 31 Dec 2002 14:37:56 +0000 |
| Subject: | RE: [PHP] Date problem | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-129775@lists.php.net to get a copy of this message | ||
> Our school holds many seminars of varying durations and dates. I want
to
> make a page which says "What's on today" which will show all the
seminars
> that are on today. However the entry in the database will show two
fields
> "Commencing Date" and "Ending date".
>
> Is there a routine in PHP I can use to find if today's date fits
between
> the commencing date and the ending date?
SELECT * FROM table WHERE CURRENT_DATE BETWEEN commence_date AND
ending_date
---John W. Holmes...
PHP Architect - A monthly magazine for PHP Professionals. Get your copy
today. http://www.phparch.com/