> 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? works if EventStartDate is a timestamp (i think) $strselect = "SELECT EventName FROM table WHERE EventStartDate > UNIX_TIMESTAMP() LIMIT 5"; if EventStartDate is not a timestamp what is it then? hope it helps -- Henrik Hansen -- 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]