edoplaza Posted April 1, 2010 Report Share Posted April 1, 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 Share on other sites More sharing options...
dianikol85 Posted April 13, 2010 Report Share Posted April 13, 2010 i think it has to do with your paging code. you must fetch your db and then write some code which do the paging, the query must have limit=1 Quote Link to comment 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.
Note: Your post will require moderator approval before it will be visible.