edoplaza Posted April 2, 2010 Share Posted April 2, 2010 Hello, I have a DB with a list of events (id, title, date, time, details). Let's say I want to display the first event like this: Title: piano recital Date: 31/11/2010 Time: 5:00 p.m. Details: Free entrance next event ---> and then just under this table I want to add a "next event" link so when you click on it the info will change and display the next event(if it happens all in the same page, better but not a must) I'd like display the next event ordered by DATE (not by id). Something like this: Title: violin recital Date: 14/12/2010 Time: 6:00 p.m. Details: Free next event ---> How do I do this? Link to comment https://forums.phpfreaks.com/topic/197354-displaying-next-event-from-a-list/ Share on other sites More sharing options...
ignace Posted April 2, 2010 Share Posted April 2, 2010 WHERE date >= now() ORDER BY date Link to comment https://forums.phpfreaks.com/topic/197354-displaying-next-event-from-a-list/#findComment-1035883 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.