| vs. | ||
| ".$gameinfo['awayname']." | ".$gameinfo['homename']." | |
".$gameinfo['scoreAway']." | - | ".$gameinfo['scoreHome']." |
"; if ($gamerecap['approved'] == "1") echo $gamerecap['recap']; else if ($gamerecap['id'] != "") echo "Recap not yet approved"; else echo "Recap not submitted."; echo "Team Stats:
"; mysql_free_result($teamstats); $indivstats = mysql_query("SELECT teams.name as teamname,player.name playername,player.picture,game_stats.* FROM game_stats INNER JOIN player on (game_stats.playerid=player.id) INNER JOIN teams ON (player.team=teams.id) WHERE approved=1 and gameid=$gameid ORDER BY type,number desc,teams.name,player.name;"); echo "Individual Stats:"; $teamstats = mysql_query("SELECT game_stats_team.*,teams.name FROM game_stats_team INNER JOIN teams ON (teams.id=game_stats_team.teamid) where gameid=$gameid and approved=1 order by type,teams.name;"); $i = 0; while ($row = mysql_fetch_assoc($teamstats)) { if ($i%2==1) $bg = "bgcolor='#dddddd'"; else $bg = ""; echo "
"; $i++; } echo " ".$row['name']." ".$row['type']." ".$row['number']."
"; include('footer.php'); ?>"; $i = 0; while ($row = mysql_fetch_assoc($indivstats)) { if ($i%2==1) $bg = "bgcolor='#dddddd'"; else $bg = ""; echo "
"; $i++; } mysql_free_result($indivstats); echo " ".$row['playername']." ".$row['teamname']." ".$row['type']." ".$row['number']."