"; $TeamNum = $_GET["Team"]; $SeasonNumber = $_GET["Season"]; $query2 = "SELECT * FROM Teams WHERE TeamNum = $TeamNum"; $result2 = mysql_fetch_array(mysql_query($query2,$connection)); $TeamName = $result2["City"] . ' ' . $result2["Club"]; print "
S" . $SeasonNumber . " Maple Cup Champions - " . $TeamName . "

"; print ''; $query = "SELECT * FROM PlayerStats WHERE Type = 'PlayOff' AND Level = 1 AND Team = $TeamNum AND Season = $SeasonNumber ORDER BY IceTime DESC" ; $result = mysql_query ($query, $connection); while ($row = mysql_fetch_array ($result)) { $PID = $row["PlayerID"]; $GP = $row["GP"]; $G = $row["G"]; $A = $row["A"]; $Pts = $row["Pts"]; $StatLine = 'GP: '.$GP.' G: '.$G.' A: '.$A.' Pts: '.$Pts; $player_query = "SELECT * FROM Players WHERE PlayerID = $PID" ; $player_result = mysql_query ($player_query, $connection); while ($player_row = mysql_fetch_array ($player_result)) { $Position = $player_row["Position"]; $PlayerName = $player_row["FirstName"] . ' ' . $player_row["LastName"]; } if ($Position == 'C'){ print ''; print ''; print ''; } } $query = "SELECT * FROM PlayerStats WHERE Type = 'PlayOff' AND Level = 1 AND Team = $TeamNum AND Season = $SeasonNumber ORDER BY IceTime DESC" ; $result = mysql_query ($query, $connection); while ($row = mysql_fetch_array ($result)) { $PID = $row["PlayerID"]; $GP = $row["GP"]; $G = $row["G"]; $A = $row["A"]; $Pts = $row["Pts"]; $StatLine = 'GP: '.$GP.' G: '.$G.' A: '.$A.' Pts: '.$Pts; $player_query = "SELECT * FROM Players WHERE PlayerID = $PID" ; $player_result = mysql_query ($player_query, $connection); while ($player_row = mysql_fetch_array ($player_result)) { $Position = $player_row["Position"]; $PlayerName = $player_row["FirstName"] . ' ' . $player_row["LastName"]; } if ($Position == 'F'){ print ''; print ''; print ''; } } $query = "SELECT * FROM PlayerStats WHERE Type = 'PlayOff' AND Level = 1 AND Team = $TeamNum AND Season = $SeasonNumber ORDER BY IceTime DESC" ; $result = mysql_query ($query, $connection); while ($row = mysql_fetch_array ($result)) { $PID = $row["PlayerID"]; $GP = $row["GP"]; $G = $row["G"]; $A = $row["A"]; $Pts = $row["Pts"]; $StatLine = 'GP: '.$GP.' G: '.$G.' A: '.$A.' Pts: '.$Pts; $player_query = "SELECT * FROM Players WHERE PlayerID = $PID" ; $player_result = mysql_query ($player_query, $connection); while ($player_row = mysql_fetch_array ($player_result)) { $Position = $player_row["Position"]; $PlayerName = $player_row["FirstName"] . ' ' . $player_row["LastName"]; } if ($Position == 'LW'){ print ''; print ''; print ''; } } $query = "SELECT * FROM PlayerStats WHERE Type = 'PlayOff' AND Level = 1 AND Team = $TeamNum AND Season = $SeasonNumber ORDER BY IceTime DESC" ; $result = mysql_query ($query, $connection); while ($row = mysql_fetch_array ($result)) { $PID = $row["PlayerID"]; $GP = $row["GP"]; $G = $row["G"]; $A = $row["A"]; $Pts = $row["Pts"]; $StatLine = 'GP: '.$GP.' G: '.$G.' A: '.$A.' Pts: '.$Pts; $player_query = "SELECT * FROM Players WHERE PlayerID = $PID" ; $player_result = mysql_query ($player_query, $connection); while ($player_row = mysql_fetch_array ($player_result)) { $Position = $player_row["Position"]; $PlayerName = $player_row["FirstName"] . ' ' . $player_row["LastName"]; } if ($Position == 'RW'){ print ''; print ''; print ''; } } $query = "SELECT * FROM PlayerStats WHERE Type = 'PlayOff' AND Level = 1 AND Team = $TeamNum AND Season = $SeasonNumber ORDER BY IceTime DESC" ; $result = mysql_query ($query, $connection); while ($row = mysql_fetch_array ($result)) { $PID = $row["PlayerID"]; $GP = $row["GP"]; $G = $row["G"]; $A = $row["A"]; $Pts = $row["Pts"]; $StatLine = 'GP: '.$GP.' G: '.$G.' A: '.$A.' Pts: '.$Pts; $player_query = "SELECT * FROM Players WHERE PlayerID = $PID" ; $player_result = mysql_query ($player_query, $connection); while ($player_row = mysql_fetch_array ($player_result)) { $Position = $player_row["Position"]; $PlayerName = $player_row["FirstName"] . ' ' . $player_row["LastName"]; } if ($Position == 'D'){ print ''; print ''; print ''; } } $query = "SELECT * FROM GoalieStats WHERE Type = 'PlayOff' AND Level = 1 AND Team = $TeamNum AND Season = $SeasonNumber ORDER BY Minutes DESC" ; $result = mysql_query ($query, $connection); while ($row = mysql_fetch_array ($result)) { $PID = $row["PlayerID"]; $GP = $row["GP"]; $W = $row["W"]; $L = $row["L"]; $SO = $row["SO"]; $player_query = "SELECT * FROM Players WHERE PlayerID = $PID" ; $player_result = mysql_query ($player_query, $connection); while ($player_row = mysql_fetch_array ($player_result)) { $Position = $player_row["Position"]; $PlayerName = $player_row["FirstName"] . ' ' . $player_row["LastName"]; } if ($GP == 0){ print ''; print ''; print ''; } else { $GAA = $row["GA"] / ($row["Minutes"] / 60); $SavePct = (($row["SA"] - $row["GA"]) / $row["SA"]) * 1000; if ($Position == 'G'){ print ''; print ''; print ''; } } } print '
Player Pos PlayOff Stats
'.$PlayerName.''.$Position.''.$StatLine.'
'.$PlayerName.''.$Position.''.$StatLine.'
'.$PlayerName.''.$Position.''.$StatLine.'
'.$PlayerName.''.$Position.''.$StatLine.'
'.$PlayerName.''.$Position.''.$StatLine.'
'.$PlayerName.''.$Position.'Did Not Play'; print '
'.$PlayerName.''.$Position.''; print 'GP: ' . $GP . ' W: ' . $W . ' L: ' . $L . ', GAA: '; print number_format($GAA,2); print ', Save %: .'; printf ("%03d", $SavePct); if ($SO > 0){ print ', SO: ' . $SO; } print '
'; ?>