include ($_SERVER['DOCUMENT_ROOT']."/inc/config.php");
if ($ses_AuthLevel >= $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 = "";
$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.";
}
?>
|