Okay. I have a showlister. Its simple enough, so Im not going to go into how it runs because it runs perfect.
My issue is when the event gets removed from the database. This took me a long time to figure out such a simple solution, but there is one error. It deletes all event prior to today and including today's events. I want todays events to stick around until the day is over.
Here is my code:
$today = date('Y-m-d');
$removeShows="Delete from shows where showDate between '1950-01-10' and '".$today."'";
$removeResult = mysql_query($removeShows) or die (mysql_error());