I have a site I am working on for a band and I would like to display their next upcoming gig/event on the home page. I have all the events/gigs in a MySQL database in the following columns,
col.1 col.2 col.3 col.4
id | location | time | date
These are all viewable on a seperate Gigs/Events page I have. What I am after though is to display the next gig/event on the home page, so I am wondering, is there a SQL query I can write in PHP on the Home Page to grab and display just the next gig/event? This will make updating the next gig very easy and it would constantly look for the next event/gig without any need for updating the site manually.
If there is an easier / better way of doing this I am open for suggestions.
Hope I have explained myself clearly :-) and any help would me buch appreciated