Calender of Events Problem

[chuckie]

What im trying to acheive is.
At the weekend i want to display where we will be in the country, then once that event has been completed it will show the next event in the database. I have the start date and the finish dates of the events im not sure on the select code though. Have tried different ideas but they either bring up the first record in the database or give me an error

Any help would be most gracefully received

[maxray]

Hi mate..

if youve got the dates in your database cant you just search from that i.e. select * where date == (Current date here)

that way when ever you go to the site it will show th ecurrent place you are..

Im far more design related than programming but thats where i would start i think..

hope its some help.

Sush