Script Working Incorectly

[twiztedbluz]

My automatic show running script dose not work. It is suppose to run everynight at 12:00AM

 

<?php
include "config.php";
$tonight= date('Y-m-d');
$event[1]="Obedience";
$event[2]="Hunting";
$event[3]="Conformation";
$event[4]="Sporting";
$event[5]="Flyball";
$event[6]="Herding";
$event[7]="Agility";
$event[8]="Working";
$event[9]="Racing";
$event[10]="Show";

//add rest of events here

for($s=1; $s<11; $s++){
$showtype="$event[$s]";

//this for loop runs once for every event

$level[1]="Level 1";
$level[2]="Level 2";
$level[3]="Level 3";
$level[4]="Level 4";
$level[5]="Level 5";
$level[6]="Level 6";
//add rest of levels here

for($l=1; $l<7; $l++){
$showlevel="$level[$l]";


$query=mysql_query("select showID,prize from shows where event='$showtype' and level='$showlevel' and rundate='$tonight'")or die(mysql_error());
$num=mysql_num_rows($query);
if($num == "0"){
continue;
}

for($i=0;$i<$num;$i++){
$showrow=mysql_fetch_array($query);

//this loop runs once for every show 

$entryquery=mysql_query("select entererID,dogID,score from show_entries where showID='$showrow[showID]' ORDER BY score DESC");
$number=mysql_num_rows($entryquery);
if($number == "0"){
continue;
}

for($m=0;$m<$number;$m++){
$entryrow=mysql_fetch_array($entryquery);

//this loop runs once for each show entry

switch($m){
case '0':
$points=200;
$place=1;
$prize=round($showrow[prize]/1);
break;
case '1':
$points=150;
$place=2;
$prize=round($showrow[prize]/2);
break;
case '2':
$points=100;
$place=3;
$prize=round($showrow[prize]/3);
break;
default:
$points=25;
break;
}

mysql_query("update dog set points=points+$points where dogID='$entryrow[dogID]'");

if($m == "0" || $m == "1" || $m == "2"){
mysql_query("update players set money=money+$prize where playerID='$entryrow[entererID]'");

mysql_query("insert into show_places(showID,entererID,dogID,place,rundate)values('$showrow[showID]','$entryrow[entererID]','$entryrow[dogID]','$place','$tonight')");
}
}
}
}
}
mysql_query("delete from shows where rundate='$tonight'");
mysql_query("delete from show_entries where rundate='$tonight'");
?>