Jump to content

Display next item from a list


edoplaza

Recommended Posts

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
Share on other sites

  • 2 weeks later...

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.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...