include('header.php');
$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 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');
?>