>
Heart . Hustle . Hard Work

--------------- 2011 STATE CHAMPIONS ---------------

Varsity Junior Varsity Sophomore Freshman

5A SIC STANDINGS

"; echo "Varsity (2013-2014)"; echo ""; echo ""; foreach ($schoolArray as &$currentSchool) { if ($loc % 2){ echo ""; } else { echo ""; } $loc ++; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo "
School Conference Wins Conference Losses Overall Wins Overall Losses
" . $currentSchool->name . "" . $currentSchool->cwin . "" . $currentSchool->closs . "" . $currentSchool->win . "" . $currentSchool->loss . "
"; 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 "JV"; echo ""; echo ""; foreach ($schoolArray as &$currentSchool) { if ($loc == 1){ echo ""; $loc = 0; } else { echo ""; $loc = 1; } echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo "
School Conference Wins Conference Losses Overall Wins Overall Losses
" . $currentSchool->name . "" . $currentSchool->cjvwin . "" . $currentSchool->cjvloss . "" . $currentSchool->jvwin . "" . $currentSchool->jvloss . "
"; 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 "Frosh/Soph"; echo ""; echo ""; foreach ($schoolArray as &$currentSchool) { if ($loc == 1){ echo ""; $loc = 0; } else { echo ""; $loc = 1; } echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo "
School Conference Wins Conference Losses Overall Wins Overall Losses
" . $currentSchool->name . "" . $currentSchool->cfrsophwin . "" . $currentSchool->cfrsophloss . "" . $currentSchool->frsophwin . "" . $currentSchool->frsophloss . "
"; echo "
"; mysqli_close($dbc); ?>