RE: [PHP] get current events from mysql query by date?
| From: | Jeff Oien | Date: | Mon, 05 Mar 2001 20:10:28 +0000 |
| Subject: | RE: [PHP] get current events from mysql query by date? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-42660@lists.php.net to get a copy of this message | ||
This is just a guess but wanted to take a shot at it.
Something like
SELECT EventID, EventName, EventDescription,
EventStartDate, EventEndDate
WHERE EventStartDate > CURRENT_DATE
ORDER BY EventStartDate ASC
LIMIT 5;
How did I do?
Jeff Oien
> I have a mysql database of events. It contains the following fields:
>
> - EventID
> - EventName
> - EventDescription
> - EventStartDate
> - EventEndDate
>
> I would like to query the database for the next 5 events from the current
> date (today). Any ideas?
>
> Regards,
>
> Matthew Delmarter
> Web Developer