5A SIC STANDINGS
";
echo "";
echo "
";
echo "
School |
Conference Wins |
Conference Losses |
Overall Wins |
Overall Losses |
";
foreach ($schoolArray as &$currentSchool) {
if ($loc % 2){
echo "";
} else {
echo "
";
}
$loc ++;
echo "" . $currentSchool->name . " | ";
echo "" . $currentSchool->cwin . " | ";
echo "" . $currentSchool->closs . " | ";
echo "" . $currentSchool->win . " | ";
echo "" . $currentSchool->loss . " | ";
echo "
";
}
echo "
";
echo "
";
$query = "SELECT * FROM stats WHERE 1 order by cjvwin DESC";
$result = mysqli_query($dbc,$query) or die
("Error with the query2");
//init the array
$schoolArray = array();
while($row = mysqli_fetch_object($result)) {
array_push($schoolArray, $row);
}
#===== Junior Varisty Table =====
echo "
";
echo "";
echo "
";
echo "
School |
Conference Wins |
Conference Losses |
Overall Wins |
Overall Losses |
";
foreach ($schoolArray as &$currentSchool) {
if ($loc == 1){
echo "";
$loc = 0;
} else {
echo "
";
$loc = 1;
}
echo "" . $currentSchool->name . " | ";
echo "" . $currentSchool->cjvwin . " | ";
echo "" . $currentSchool->cjvloss . " | ";
echo "" . $currentSchool->jvwin . " | ";
echo "" . $currentSchool->jvloss . " | ";
echo "
";
}
echo "
";
echo "
";
$query = "SELECT * FROM stats WHERE 1 order by cfrsophwin DESC";
$result = mysqli_query($dbc,$query) or die
("Error with the query3");
//init the array
$schoolArray = array();
while($row = mysqli_fetch_object($result)) {
array_push($schoolArray, $row);
}
#===== Fresh/Soph Table =====
echo "
";
echo "";
echo "
";
echo "
School |
Conference Wins |
Conference Losses |
Overall Wins |
Overall Losses |
";
foreach ($schoolArray as &$currentSchool) {
if ($loc == 1){
echo "";
$loc = 0;
} else {
echo "
";
$loc = 1;
}
echo "" . $currentSchool->name . " | ";
echo "" . $currentSchool->cfrsophwin . " | ";
echo "" . $currentSchool->cfrsophloss . " | ";
echo "" . $currentSchool->frsophwin . " | ";
echo "" . $currentSchool->frsophloss . " | ";
echo "
";
}
echo "
";
echo "
";
mysqli_close($dbc);
?>