Re: 1h work to solve the dumbest error there is
$query = sprintf("SELECT rank,prize FROM prizes WHERE type = 'supporter'");
change to
$query = sprintf("SELECT rank,prize FROM prizes WHERE type=supporter")
AND
$prizeResult = mysql_query($query);
change to
$prizeResult = mysql_query($query) or die(mysql_error());
That will tell you exactly what is wrong with the query. It was made for a reason, to make debugging faster.