selecting the next date

[Jarod]

ive got this code that takes a band tour info. I need it to automatically jump to the next date after the day has pass already. So if a show was on the 1st and its the 5th and theres a show on the 10th it will automatically show the date of the next show

i think you use this but its not working.

$tour = @("SELECT *, UNIX_TIMESTAMP(date) as date from tour where TO_DAYS(NOW()) - TO_DAYS(date) <= 0") or die("Couldn't ececute query.".mysql_error());

[barand]

$today = date('Y-m-d');

$query = "select * from tour where date > '$today' ";

[dombey]

If you want to only get the next show run the above query but add Limit 1 to the end.