Women"; else print "Men"; ?>

This page displays a summary of the roster and schedule data entered so far for each team in the given season and gender:

Teams are grouped by Division I, then II, then III.
Team names are links to the content admin edit page for that team.
You may edit the roster or schedule by clicking the "Edit" link for that team.
Links will not work if you are not already logged into the admin.
For rosters, the number of players entered so far is shown.
For schedules, the number of games entered so far is shown, along with the last date/time the team's schedule was modified.
Last modification time is not available for the roster information.

\n \n\n"; while ($row=mysqli_fetch_array($result)) { extract($row); // If this team is of a different division, print the separator if ($division != $save_division) { print "\n \n\n"; $save_division=$division; } print "\n"; // Link to team edit page print " \n"; // Link to team edit roster page print " \n"; // Print # players entered $sql2 = "SELECT {$gender}players.ID,{$gender}playerYxY.ID as YxYid,school_ID " . "FROM {$gender}playerYxY,{$gender}players " . "WHERE player_ID={$gender}players.ID AND year='$season' " . "AND school_ID=$teamID "; ; $result_roster=mysqli_query($dbh,$sql2); $players_entered=mysqli_num_rows($result_roster); print " \n"; // Link to team edit schedule page print " \n"; // Print # games entered $sql3 = "SELECT DISTINCT * FROM {$gender}games " . "WHERE (visitor='$teamcode' OR home='$teamcode') "; $result_sched=mysqli_query($dbh,$sql3); $games_entered=mysqli_num_rows($result_sched); print " \n"; // Print lastmod $sql4 = "SELECT MAX(modtime) as modtime FROM {$gender}games " . "WHERE (visitor='$teamcode' OR home='$teamcode') "; $result_modtime=mysqli_query($dbh,$sql4); $modtime_row=mysqli_fetch_array($result_modtime); extract($modtime_row); $modtime_string=substr($modtime,4,2) . "/" . substr($modtime,6,2) . "/" . substr($modtime,2,2) . " " . substr($modtime,8,2) . ":" . substr($modtime,10,2) . ":" . substr($modtime,12,2); print " \n"; print "\n"; $players_entered=0; $games_entered=0; } ?>

Team	Roster	Players Entered	Schedule	Games Entered	Last Changed
Division $save_division
Division $division
$teamname	Edit	$players_entered	Edit	$games_entered	$modtime_string