= $AuthLevel_BoardBottom) { include ($_SERVER['DOCUMENT_ROOT']."/inc/sql_connect.php"); $Teams = $TeamYear."R_"; $sql = "SELECT People.*, PlayerFamily.*, Player.*, Positions.*, Groups.* FROM People, PlayerFamily, Player, Positions, Groups WHERE Player.PeopleID = PlayerFamily.RegistrationID and PlayerFamily.P_PeopleID = People.PeopleID and People.PeopleID = Positions.PeopleID and Positions.GroupID = Groups.GroupID and Positions.GroupID LIKE '$Teams' ORDER BY Groups.GroupID ASC, People.LastName ASC, People.FirstName ASC"; include ($_SERVER['DOCUMENT_ROOT']."/inc/sql_execute.php"); echo "

- CGFP Players Uniforms -

"; // Start results formatting $TableStart = ""; $TableEnd = "
"; $RowStart = ""; $RowEnd = ""; $Delim = ""; // echo "$numrows total position responses $Eol"; echo $TableStart; echo $RowStart."Registration #".$Delim."PeopleID".$Delim."First Name".$Delim."Last Name".$Delim."Division".$Delim."Team Letter".$Delim."Team Name".$Delim."Shirt".$Delim."Shorts".$Delim."Socks".$Delim."Extra Socks".$Delim."Visor Name".$RowEnd; // Format results by row while ($row = mysql_fetch_array($sql_result)) { $RegistrationID = $row["RegistrationID"]; $PeopleID = $row["PeopleID"]; $FirstName = $row["FirstName"]; $LastName = $row["LastName"]; $GroupDivAge = $row["GroupDivAge"]; $GroupChar = $row["GroupChar"]; $GroupName = $row["GroupName"]; $Shirt = $row["Shirt"]; $Shorts = $row["Shorts"]; $Socks = $row["Socks"]; $SocksExtra = $row["SocksExtra"]; $VisorName = $row["VisorName"]; echo $RowStart.$RegistrationID.$Delim.$PeopleID.$Delim.$FirstName.$Delim.$LastName.$Delim.$GroupDivAge.$Delim.$GroupChar.$Delim.$GroupName.$Delim.$Shirt.$Delim.$Shorts.$Delim.$Socks.$Delim.$SocksExtra.$Delim.$VisorName.$RowEnd; } echo $TableEnd; include ($_SERVER['DOCUMENT_ROOT']."/inc/sql_close.php"); } ELSE { echo "Only Board of Directors and above may view this file."; } ?>