Organise event listings from MySQL database

[damnedgentleman]

Hi there!

 

My name is Andy.  I'm relatively new to PHP.  Despite this, my project (an events listings website for a live music venue) is coming along at a steady rate.  However, I have become somewhat confused by the following:

 

I have a MySQL table named 'events'.  The table contains the following obvious fields 'eventID', 'eventDate', 'eventArtists', 'eventDesc', 'eventEntryFee'.  It can be edited from a basic content management page.

 

I would like the main page of the website to pull all the information out of the database, displaying the up and coming week's events starting with today's event.  Further, I'd like a 'next' option, giving the site user the choice to scan further ahead should they choose. 

 

Does anybody have any ideas where I should start?

 

Thanks for reading,

 

Andy