ordering by date time stamp from todays date

[eluser]R_Nelson[/eluser]
i got my calendar working very nice and what i would like to do is sort the dates in the DB from today till i find 1 then use that info to make a next show box on my right side bar i can get the DB to show me all the dates and i know i can use limit 1 to get just one but how do i make Mysql pick the next day that there is a show booked for including that day!