Select Date of Melee Competition: \n"; $result = getResult("SELECT Day FROM meleescores GROUP BY Day ORDER BY Day DESC",$cnt); for($i = 0; $i<$cnt; $i++) { list($dayList) = getVals($result); echo "$dayList\n"; } echo " \n"; ///////// if ($day != "") { echo "
\n"; } $result = getResult("SELECT * FROM meleescores WHERE Day='$day' ORDER BY Game ASC",$cnt); for($i = 0; $i<$cnt; $i++) { list($id,$game,$pin1,$score1,$pin2,$score2,$reporter,$day) = getVals($result); list($club1,$person1) = getRow("SELECT Club,Name FROM meleeprofiles WHERE ID=$pin1"); list($club2,$person2) = getRow("SELECT Club,Name FROM meleeprofiles WHERE ID=$pin2"); $club1 = colorClub($club1); $club2 = colorClub($club2); if ($score1 > $score2) $outcome = "$club1 Win"; else if ($score2 > $score1) $outcome = "$club2 Win"; else $outcome = "Tie"; echo "\n"; } echo "

Game	Club1	Person1	Score1	Club2	Person2	Score2	Outcome	Reporting IP
$game" . (($admin) ? " UnReport" : "") . "	$club1	$person1	$score1	$club2	$person2	$score2	$outcome	$reporter

\n"; include("footer.php"); ?>