Hi there, basically i'm trying to write a php script that allows me to retrieve the tour dates for my band from a MySQL table. I want the gigs.php page to show every upcoming gig that there is.
On gigs.php i want a link to gigarchive.php which features all passed gigs. This page should update after the day on which the gig occured has passed.
Simularily the gig.php page should update once the day that a gig is occuring has finished.
I guess this would have to be done by some sort of date filter. e.g.
SELECT * FROM 'gigs' WHERE 'date' < Now()
As you can see i'm probably on completly the wrong track. Thanks in advance.