"; $query_teams = "select school, schoolid, sum(m_a_gs) as m_a_gs, sum(w_a_gs) as w_a_gs, sum(m_a_sl) as m_a_sl, sum(w_a_sl) as w_a_sl, sum(m_n_fr) as m_n_fr, sum(w_n_fr) as w_n_fr, sum(m_n_cl) as m_n_cl, sum(w_n_cl) as w_n_cl, sum(pts) as pts from teamresults where season = '".$season."' and postseason = 'n' group by schoolid order by pts desc"; $result_teams = mysql_query($query_teams); $num_results_teams = mysql_num_rows($result_teams); $query_date = "select max(dateend) as date from schedule where season = '".$season."' and postseason = 'n' and complete = 'y' order by date"; $result_date = mysql_query($query_date); $num_results_date = mysql_num_rows($result_date); $row_date = mysql_fetch_array($result_date); $query_done = "select eventid from schedule where season = '".$season."' and postseason = 'n' and complete = 'y' group by eventid"; $result_done = mysql_query($query_done); $num_results_done = mysql_num_rows($result_done); $query_total = "select eventid from schedule where season = '".$season."' and postseason = 'n' group by eventid"; $result_total = mysql_query($query_total); $num_results_total = mysql_num_rows($result_total); $convert_date = date("F j, Y", strtotime($row_date["date"])); echo " 

"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; for ($i_teams = 0; $i_teams < $num_results_teams; $i_teams++) { $row_teams = mysql_fetch_array($result_teams); $rank = $i_teams+1; $m_a_gs1 = floor($row_teams["m_a_gs"]); $m_a_gs2 = number_format($m_a_gs1); $w_a_gs1 = floor($row_teams["w_a_gs"]); $w_a_gs2 = number_format($w_a_gs1); $m_a_sl1 = floor($row_teams["m_a_sl"]); $m_a_sl2 = number_format($m_a_sl1); $w_a_sl1 = floor($row_teams["w_a_sl"]); $w_a_sl2 = number_format($w_a_sl1); $m_n_cl1 = floor($row_teams["m_n_cl"]); $m_n_cl2 = number_format($m_n_cl1); $w_n_cl1 = floor($row_teams["w_n_cl"]); $w_n_cl2 = number_format($w_n_cl1); $m_n_fr1 = floor($row_teams["m_n_fr"]); $m_n_fr2 = number_format($m_n_fr1); $w_n_fr1 = floor($row_teams["w_n_fr"]); $w_n_fr2 = number_format($w_n_fr1); $pts1 = floor($row_teams["pts"]); $pts2 = number_format($pts1); echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo "
2008 Final Standings | 2009 Final Standings | 2010 Final Standings | 2011 Final Standings | 2012 Final Standings | 2013 Final Standings | 2014 Standings

".$season." RMISA Regular Season Team Standings
Through ".$convert_date.""; if ($num_results_done < $num_results_total) { echo " (".$num_results_done." of ".$num_results_total." regular season meets)"; } else { echo " (FINAL)"; } echo "
 
 AlpineNordic 
 Giant SlalomSlalomFreestyleClassical 
Rank  SchoolMen Women Men Women Men Women Men Women Total Points 
".$rank.".  ".$row_teams["school"]." "; echo ""; echo ""; echo "
".$m_a_gs2.""; if ($m_a_gs1 != $row_teams["m_a_gs"]) { echo "½"; } echo " "; echo "
"; echo "
"; echo ""; echo ""; echo "
".$w_a_gs2.""; if ($w_a_gs1 != $row_teams["w_a_gs"]) { echo "½"; } echo " "; echo "
"; echo "
"; echo ""; echo ""; echo "
".$m_a_sl2.""; if ($m_a_sl1 != $row_teams["m_a_sl"]) { echo "½"; } echo " "; echo "
"; echo "
"; echo ""; echo ""; echo "
".$w_a_sl2.""; if ($w_a_sl1 != $row_teams["w_a_sl"]) { echo "½"; } echo " "; echo "
"; echo "
"; echo ""; echo ""; echo "
".$m_n_fr2.""; if ($m_n_fr1 != $row_teams["m_n_fr"]) { echo "½"; } echo " "; echo "
"; echo "
"; echo ""; echo ""; echo "
".$w_n_fr2.""; if ($w_n_fr1 != $row_teams["w_n_fr"]) { echo "½"; } echo " "; echo "
"; echo "
"; echo ""; echo ""; echo "
".$m_n_cl2.""; if ($m_n_cl1 != $row_teams["m_n_cl"]) { echo "½"; } echo " "; echo "
"; echo "
"; echo ""; echo ""; echo "
".$w_n_cl2.""; if ($w_n_cl1 != $row_teams["w_n_cl"]) { echo "½"; } echo " "; echo "
"; echo "
"; echo ""; echo ""; echo "
".$pts2.""; if ($pts1 != $row_teams["pts"]) { echo "½"; } echo " "; echo "
"; echo "

"; $query_men = "select school, schoolid, (sum(m_a_gs)+sum(m_a_sl)+sum(m_n_fr)+sum(m_n_cl)) as pts from teamresults where season = '".$season."' and postseason = 'n' group by schoolid order by pts desc"; $result_men = mysql_query($query_men); $num_results_men = mysql_num_rows($result_men); $query_women = "select school, schoolid, (sum(w_a_gs)+sum(w_a_sl)+sum(w_n_fr)+sum(w_n_cl)) as pts from teamresults where season = '".$season."' and postseason = 'n' group by schoolid order by pts desc"; $result_women = mysql_query($query_women); $num_results_women = mysql_num_rows($result_women); $query_nordic = "select school, schoolid, (sum(w_n_cl)+sum(w_n_fr)+sum(m_n_fr)+sum(m_n_cl)) as pts from teamresults where season = '".$season."' and postseason = 'n' group by schoolid order by pts desc"; $result_nordic = mysql_query($query_nordic); $num_results_nordic = mysql_num_rows($result_nordic); $query_mnordic = "select school, schoolid, (sum(m_n_fr)+sum(m_n_cl)) as pts from teamresults where season = '".$season."' and postseason = 'n' group by schoolid order by pts desc"; $result_mnordic = mysql_query($query_mnordic); $num_results_mnordic = mysql_num_rows($result_mnordic); $query_wnordic = "select school, schoolid, (sum(w_n_cl)+sum(w_n_fr)) as pts from teamresults where season = '".$season."' and postseason = 'n' group by schoolid order by pts desc"; $result_wnordic = mysql_query($query_wnordic); $num_results_wnordic = mysql_num_rows($result_wnordic); $query_alpine = "select school, schoolid, (sum(m_a_gs)+sum(m_a_sl)+sum(w_a_gs)+sum(w_a_sl)) as pts from teamresults where season = '".$season."' and postseason = 'n' group by schoolid order by pts desc"; $result_alpine = mysql_query($query_alpine); $num_results_alpine = mysql_num_rows($result_alpine); $query_malpine = "select school, schoolid, (sum(m_a_gs)+sum(m_a_sl)) as pts from teamresults where season = '".$season."' and postseason = 'n' group by schoolid order by pts desc"; $result_malpine = mysql_query($query_malpine); $num_results_malpine = mysql_num_rows($result_malpine); $query_walpine = "select school, schoolid, (sum(w_a_gs)+sum(w_a_sl)) as pts from teamresults where season = '".$season."' and postseason = 'n' group by schoolid order by pts desc"; $result_walpine = mysql_query($query_walpine); $num_results_walpine = mysql_num_rows($result_walpine); echo "
"; echo ""; echo ""; echo ""; echo "
"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; for ($i_malpine = 0; $i_malpine < $num_results_malpine; $i_malpine++) { $row_malpine = mysql_fetch_array($result_malpine); $rank = $i_malpine+1; $pts_malpine1 = floor($row_malpine["pts"]); $pts_malpine2 = number_format($pts_malpine1); echo ""; echo ""; echo ""; echo ""; } echo "
Men's Alpine Standings
Rank  SchoolPoints 
".$rank.".  ".$row_malpine["school"]." "; echo ""; echo ""; echo "
".$pts_malpine2.""; if ($pts_malpine1 != $row_malpine["pts"]) { echo "½"; } echo " "; echo "
"; echo "
"; echo "
"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; for ($i_walpine = 0; $i_walpine < $num_results_walpine; $i_walpine++) { $row_walpine = mysql_fetch_array($result_walpine); $rank = $i_walpine+1; $pts_walpine1 = floor($row_walpine["pts"]); $pts_walpine2 = number_format($pts_walpine1); echo ""; echo ""; echo ""; echo ""; } echo "
Women's Alpine Standings
Rank  SchoolPoints 
".$rank.".  ".$row_walpine["school"]." "; echo ""; echo ""; echo "
".$pts_walpine2.""; if ($pts_walpine1 != $row_walpine["pts"]) { echo "½"; } echo " "; echo "
"; echo "
"; echo "
"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; for ($i_alpine = 0; $i_alpine < $num_results_alpine; $i_alpine++) { $row_alpine = mysql_fetch_array($result_alpine); $rank = $i_alpine+1; $pts_alpine1 = floor($row_alpine["pts"]); $pts_alpine2 = number_format($pts_alpine1); echo ""; echo ""; echo ""; echo ""; } echo "
Combined Alpine Standings
Rank  SchoolPoints 
".$rank.".  ".$row_alpine["school"]." "; echo ""; echo ""; echo "
".$pts_alpine2.""; if ($pts_alpine1 != $row_alpine["pts"]) { echo "½"; } echo " "; echo "
"; echo "
"; echo "

"; echo "
"; echo ""; echo ""; echo ""; echo "
"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; for ($i_mnordic = 0; $i_mnordic < $num_results_mnordic; $i_mnordic++) { $row_mnordic = mysql_fetch_array($result_mnordic); $rank = $i_mnordic+1; $pts_mnordic1 = floor($row_mnordic["pts"]); $pts_mnordic2 = number_format($pts_mnordic1); echo ""; echo ""; echo ""; echo ""; } echo "
Men's Nordic Standings
Rank  SchoolPoints 
".$rank.".  ".$row_mnordic["school"]." "; echo ""; echo ""; echo "
".$pts_mnordic2.""; if ($pts_mnordic1 != $row_mnordic["pts"]) { echo "½"; } echo " "; echo "
"; echo "
"; echo "
"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; for ($i_wnordic = 0; $i_wnordic < $num_results_wnordic; $i_wnordic++) { $row_wnordic = mysql_fetch_array($result_wnordic); $rank = $i_wnordic+1; $pts_wnordic1 = floor($row_wnordic["pts"]); $pts_wnordic2 = number_format($pts_wnordic1); echo ""; echo ""; echo ""; echo ""; } echo "
Women's Nordic Standings
Rank  SchoolPoints 
".$rank.".  ".$row_wnordic["school"]." "; echo ""; echo ""; echo "
".$pts_wnordic2.""; if ($pts_wnordic1 != $row_wnordic["pts"]) { echo "½"; } echo " "; echo "
"; echo "
"; echo "
"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; for ($i_nordic = 0; $i_nordic < $num_results_nordic; $i_nordic++) { $row_nordic = mysql_fetch_array($result_nordic); $rank = $i_nordic+1; $pts_nordic1 = floor($row_nordic["pts"]); $pts_nordic2 = number_format($pts_nordic1); echo ""; echo ""; echo ""; echo ""; } echo "
Combined Nordic Standings
Rank  SchoolPoints 
".$rank.".  ".$row_nordic["school"]." "; echo ""; echo ""; echo "
".$pts_nordic2.""; if ($pts_nordic1 != $row_nordic["pts"]) { echo "½"; } echo " "; echo "
"; echo "
"; echo "

"; echo "
"; echo ""; echo ""; echo "
"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; for ($i_men = 0; $i_men < $num_results_men; $i_men++) { $row_men = mysql_fetch_array($result_men); $rank = $i_men+1; $pts_men1 = floor($row_men["pts"]); $pts_men2 = number_format($pts_men1); echo ""; echo ""; echo ""; echo ""; } echo "
Combined Men's Standings
Rank  SchoolPoints 
".$rank.".  ".$row_men["school"]." "; echo ""; echo ""; echo "
".$pts_men2.""; if ($pts_men1 != $row_men["pts"]) { echo "½"; } echo " "; echo "
"; echo "
"; echo "
"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; for ($i_women = 0; $i_women < $num_results_women; $i_women++) { $row_women = mysql_fetch_array($result_women); $rank = $i_women+1; $pts_women1 = floor($row_women["pts"]); $pts_women2 = number_format($pts_women1); echo ""; echo ""; echo ""; echo ""; } echo "
Combined Women's Standings
Rank  SchoolPoints 
".$rank.".  ".$row_women["school"]." "; echo ""; echo ""; echo "
".$pts_women2.""; if ($pts_women1 != $row_women["pts"]) { echo "½"; } echo " "; echo "
"; echo "
"; echo "

Pursuant to RMISA bylaw 6.A.1-7, the RMISA recognizes the RMISA Conference regular season team champions. The award is based on combining the points for all meets prior to the Regional Championship and will be presented at the RMISA Regional banquet. Additionally, recognized will be the men’s combined regular season team champion, the women’s combined regular season team champion, the men’s alpine regular season team champion, the women’s alpine regular season team champion, the men’s nordic regular season team champion and the women’s nordic regular season team champion.
 "; echo ""; include('/var/www/vhosts/rmisaskiing.com/httpdocs/library/footer.php'); ?>