include ($_SERVER['DOCUMENT_ROOT']."/inc/config.php");
$Class = "RS";
include ($_SERVER['DOCUMENT_ROOT']."/inc/sql_connect.php");
// Create SQL statement
$sql = "SELECT GroupDiv.*, Groups.*
FROM GroupDiv, Groups
WHERE GroupDiv.GroupDivAge = Groups.GroupDivAge AND GroupType = 'Team' AND GroupYear = $Year AND Groups.GroupClass = '$Class'
ORDER BY GroupDiv.GroupDivAge, GroupListOrder ASC";
include ($_SERVER['DOCUMENT_ROOT']."/inc/sql_execute.php");
?>
unset($GroupHead); //Display group division as header. Initially set blank.
unset($PlayerCount); //Display's number of players
// Format results by row
while ($row = mysql_fetch_array($sql_result))
{
$GroupID = $row["GroupID"];
$GroupYear = $row["GroupYear"];
$GroupClass = $row["GroupClass"];
$GroupDiv = $row["GroupDiv"];
$GroupDivName = $row["GroupDivName"];
if ($GroupHead != $GroupDivName) {
$GroupHead = $GroupDivName;
}
$Team = $row["GroupChar"];
$Color = $row["GroupColor"];
$GroupName = $row["GroupName"];
$GroupSong = $row["GroupSong"];
?>
echo $GroupDiv; ?> |
echo "$Team";?> |
echo "$Color";?> |
echo "$GroupName"; ?> |
|
echo $GroupSong; ?> |
} // ends row formatting area
include ($_SERVER['DOCUMENT_ROOT']."/inc/sql_close.php");
?>