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? Quote 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 Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.