include ('header.php');
$results = mysql_query("select position,teams.name as teamname from bracket left join teams on (bracket.team=teams.id);");
while($row = mysql_fetch_assoc($results))
{
$myHash[$row['position']] = $row['teamname'];
}
?>
echo "
".$myHash['Champ']."
".$myHash['A01']."
".$myHash['A02']."
".$myHash['A03']."
".$myHash['A04']."
".$myHash['A11']."
".$myHash['A12']."
".$myHash['A13']."
".$myHash['A14']."
".$myHash['A21']."
".$myHash['A22']."
".$myHash['A31']."
".$myHash['B31']."
".$myHash['B01']."
".$myHash['B02']."
".$myHash['B03']."
".$myHash['B04']."
".$myHash['B11']."
".$myHash['B12']."
".$myHash['B13']."
".$myHash['B14']."
".$myHash['B21']."
".$myHash['B22']." ";
?>
|
$teams = mysql_query("select users.nickname,teams.name as teamname,teams.id as teamid from users_teams inner join users on (users_teams.user=users.id) inner join teams on (users_teams.team=teams.id) order by teams.name;");
$teamSelect="";
$teamHash;
while ($row = mysql_fetch_assoc($teams))
{
$teamHash[$row['teamid']] = $row['teamname'];
$playerHash[$row['teamid']] = $row['nickname'];
}
mysql_free_result($teams);
$games = mysql_query("select * from game where playoff=1 order by round desc;");
echo "Game Schedule |
";
$prevRound = "";
while ($res = mysql_fetch_assoc($games))
{
if ($prevRound != $res['round'])
{
echo "Round ".$res['round']." |
";
$prevRound = $res['round'];
}
$gameid = $res['id'];
$hometeam = $teamHash[$res['playerHome']];
$homeplayer = $playerHash[$res['playerHome']];
$awayteam = $teamHash[$res['playerAway']];
$awayplayer = $playerHash[$res['playerAway']];
$score = "Submit Results";
if ($res['scoreHome'] != "" && $res['scoreAway'] != "")
$score = "".$res['scoreAway']." - ".$res['scoreHome']."";
echo "
".$awayteam." (".$awayplayer.") | vs. | ".$hometeam." (".$homeplayer.") | $score |
|
";
}
mysql_free_result($games);
echo "
";
include('footer.php');
?>