setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION ); #Set Query for Team $STH = $DBH->prepare('SELECT idTeamAssignment, SeasonDisplay, TeamName, GamesPlayed, TeamWins, TeamLoss, TeamTie, TeamOTLoss, TeamPts, TeamGoals, TeamGoalsAgainst, TeamShots, TeamShotsAgainst, TeamPIM FROM teamstat WHERE idteam=7 ORDER BY SeasonStart DESC'); $STH->execute(); #Set Query for totals footer $STHTotals = $DBH->prepare('SELECT idTeamAssignment, TeamName, SUM(GamesPlayed), SUM(TeamWins), SUM(TeamLoss), SUM(TeamTie), SUM(TeamOTLoss), SUM(TeamPts), SUM(TeamGoals), SUM(TeamGoalsAgainst), SUM(TeamShots), SUM(TeamShotsAgainst), SUM(TeamPIM) FROM teamstat WHERE idteam=7'); #Prepare Output for HTML $Teamstat = ''; while($row = $STH->fetch(PDO::FETCH_ASSOC)) { $Teamstat .= ''; } $STHTotals->execute(); $STHsum = $STHTotals->fetch(PDO::FETCH_ASSOC); $Teamstattotal = ''; include 'header.php'; echo '

Historical data for the '; echo $teamname; echo '

'; echo $Teamstat; echo $Teamstattotal; echo '

Season	Games Played	Wins	Losses	Ties	OTL	Points	Goals	Goals Against	Shots	Shots Against	PIM
'.$row['SeasonDisplay'].'	'.$row['GamesPlayed'].'	'.$row['TeamWins'].'	'.$row['TeamLoss'].'	'.$row['TeamTie'].'	'.$row['TeamOTLoss'].'	'.$row['TeamPts'].'	'.$row['TeamGoals'].'	'.$row['TeamGoalsAgainst'].'	'.$row['TeamShots'].'	'.$row['TeamShotsAgainst'].'	'.$row['TeamPIM'].'
Total	'.$STHsum['SUM(GamesPlayed)'].'	'.$STHsum['SUM(TeamWins)'].'	'.$STHsum['SUM(TeamLoss)'].'	'.$STHsum['SUM(TeamTie)'].'	'.$STHsum['SUM(TeamOTLoss)'].'	'.$STHsum['SUM(TeamPts)'].'	'.$STHsum['SUM(TeamGoals)'].'	'.$STHsum['SUM(TeamGoalsAgainst)'].'	'.$STHsum['SUM(TeamShots)'].'	'.$STHsum['SUM(TeamShotsAgainst)'].'	'.$STHsum['SUM(TeamPIM)'].'

'; include 'footer.php'; ?>