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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
