"; echo "
Score
  ".$gameInfo['awayteam']." 
  ".$gameInfo['hometeam']." 
"; } else { echo "Score has already been submitted:
".$gameInfo['awayteam']." ".$scoreSubmitted['awayScore']." - ".$gameInfo['hometeam']." ".$scoreSubmitted['homeScore']."
"; } if ($gameInfo['playoff'] == 1) { $pkscoreSubmitted = mysql_fetch_assoc(mysql_query("SELECT * FROM game_scoresubmit WHERE gameid=$gameid and type='PK';")); if ($pkscoreSubmitted['id'] == "") { echo "
"; echo "
Penalty Kick Final
  ".$gameInfo['awayteam']." 
  ".$gameInfo['hometeam']." 
"; } else { echo "PK Score has been submitted:
".$gameInfo['awayteam']." ".$pkscoreSubmitted['awayScore']." - ".$gameInfo['hometeam']." ".$pkscoreSubmitted['homeScore']."
"; } } //recap section $recapSubmitted = mysql_fetch_assoc(mysql_query("SELECT * FROM game_recap WHERE gameid=$gameid;")); if ($recapSubmitted['id'] == "") { echo "
"; echo "
Game Recap (Comments or Summary)
 
"; } else { echo "Recap has been submitted:
".$recapSubmitted['recap']."
"; } // team stats echo "
Submit Team Stats for BOTH Teams:
"; $teamStatTypes = array('Total Shots','Shots on Target', 'Possession %'); echo ""; echo "
Team:
Type:
Number of Type:
  (i.e. 49 for 49% possession)
"; $players = mysql_query("select id,name,team,position from player where team=".$gameInfo['playerAway']." OR team=".$gameInfo['playerHome']." order by team,name;"); //submit new stats echo "
Submit Individual Stats for BOTH Teams:
"; $types = array('Goal','Clean Sheet','Red Card', 'Yellow Card'); echo "
Player:
Type:
Number of Type (i.e. 2 for 2 red cards):

"; echo " Team Stats Submitted for this Game
"; $teamstats = mysql_query("SELECT teams.name as teamname, game_stats_team.* FROM game_stats_team INNER JOIN teams ON (game_stats_team.teamid=teams.id) WHERE gameid=$gameid ORDER BY teams.name;"); echo ""; while ($row=mysql_fetch_assoc($teamstats)) { echo ""; } echo "
TeamStat TypeNumberApproved
".$row['teamname']."".$row['type']."".$row['number']."".$row['approved']."

"; mysql_free_result($teamstats); // submitted stats echo " Individual Stats Submitted for this Game
"; $stats = mysql_query("SELECT teams.name as teamname,game_stats.*,player.name as playername,player.position FROM game_stats INNER JOIN player ON game_stats.playerid=player.id INNER JOIN teams ON (player.team=teams.id) WHERE gameid=$gameid ORDER BY teams.name,player.name;"); echo ""; while ($row=mysql_fetch_assoc($stats)) { echo ""; } echo "
PlayerStat TypeNumberApproved
".$row['teamname']." - ".$row['playername']." (".$row['position'].")".$row['type']."".$row['number']."".$row['approved']."
"; mysql_free_result($stats); include('footer.php'); ?>