MySQL Date Finding

wxdqz

New Member
Hi guys/gals,

I am starting up a website for my Rugby team, and I want to have a fixtures and results service on there. I have setup a MySQL table 'fixtures' with the following fields

home_team
away_team
home_score
away_score
game_date

What I would like to do is have my index.php work out which fixture is next and display that. Unfortunately, as a relative beginner I am not sure how to do that.

If anyone could help Id be very grateful.

Ben
 
Back
Top