"; $query_m_g = "select skierid as skiid, first, last, team, IFNULL((select indvpts from results where (results.gender = 'f' and racetype = 's' and skierid = skiid and season = '".$season."') order by indvpts desc limit 0,1),0) as res1, IFNULL((select indvpts from results where (results.gender = 'f' and racetype = 's' and skierid = skiid and season = '".$season."') order by indvpts desc limit 1,1),0) as res2, IFNULL((select indvpts from results where (results.gender = 'f' and racetype = 's' and skierid = skiid and season = '".$season."') order by indvpts desc limit 2,1),0) as res3, (IFNULL((select indvpts from results where (results.gender = 'f' and racetype = 's' and skierid = skiid and season = '".$season."') order by indvpts desc limit 0,1),0) + IFNULL((select indvpts from results where (results.gender = 'f' and racetype = 's' and skierid = skiid and season = '".$season."') order by indvpts desc limit 1,1),0)) as pts from results, skiers where (results.skierid = skiers.id) and results.gender = 'f' and racetype = 's' and skierid != 0 and season = '".$season."' and teamid < 10 and teamid > 0 group by skierid order by pts desc, res3 desc, last, first"; $result_m_g = mysql_query($query_m_g); $num_results_m_g = mysql_num_rows($result_m_g); $query_date = "select max(dateend) as date from schedule where season = '".$season."' and ncaa = 'n' and complete = 'y'"; $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 ncaa = 'n' and complete = 'y' and (eventtype = 'a' or eventtype = 'b') and (eventtype2 = 'b' or eventtype2 = 'a' or eventtype2 = 's') group by eventid"; $result_done = mysql_query($query_done); $num_results_done = mysql_num_rows($result_done); $query_sched = "select * from schedule where season = '".$season."' and ncaa = 'n' and (eventtype = 'a' or eventtype = 'b') and (eventtype2 = 'b' or eventtype2 = 'a' or eventtype2 = 's') group by eventid order by scheduleid"; $result_sched = mysql_query($query_sched); $num_results_sched = mysql_num_rows($result_sched); $query_total = "select eventid from schedule where season = '".$season."' and ncaa = 'n' and (eventtype = 'a' or eventtype = 'b') and (eventtype2 = 'b' or eventtype2 = 'a' or eventtype2 = 's') 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 " 

".$season." NCAA Qualifying - Women's Slalom
Through ".$convert_date.""; if ($num_results_done < $num_results_total) { echo " (".$num_results_done." of ".$num_results_total." meets leading up to NCAAs)"; } else { echo " (FINAL)"; } if ($season == "2007-08") { echo "
Women's Slalom Rankings In PDF Format

"; } elseif ($season == "2008-09") { echo "
Women's Slalom Rankings In PDF Format

"; } echo "

"; echo ""; echo ""; echo ""; $col_sched = 375/$num_results_sched; for ($i_sched = 0; $i_sched < $num_results_sched; $i_sched++) { $row_sched = mysql_fetch_array($result_sched); echo ""; } echo ""; echo ""; echo ""; echo ""; echo ""; $pts_check = 0; for ($i_m_g = 0; $i_m_g < $num_results_m_g; $i_m_g++) { $row_m_g = mysql_fetch_array($result_m_g); $rank = $i_m_g+1; if ($i_m_g/2 == round($i_m_g/2)) { echo ""; } else { echo ""; } if ($row_m_g["pts"] == $pts_check) { echo ""; } else { echo ""; } echo ""; $query_sched2 = "select * from schedule where season = '".$season."' and ncaa = 'n' group by scheduleid order by scheduleid"; $result_sched2 = mysql_query($query_sched2); $num_results_sched2 = mysql_num_rows($result_sched2); for ($i_sched2 = 0; $i_sched2 < $num_results_sched; $i_sched2 ++) { $row_sched2 = mysql_fetch_array($result_sched2); $query_invite = "select * from results where skierid = '".$row_m_g["skiid"]."' and eventid = '".$row_sched2["scheduleid"]."' and gender = 'f' and racetype = 's' order by eventid"; $result_invite = mysql_query($query_invite); $num_results_invite = mysql_num_rows($result_invite); $row_invite = mysql_fetch_array($result_invite); if ($num_results_invite == 0) { echo ""; } else { if ($row_invite["dq"] > 0) { echo ""; } elseif ($row_invite["dns"] > 0) { echo ""; } elseif ($row_invite["dnf"] > 0) { echo ""; } else { echo ""; } } } echo ""; echo ""; echo ""; echo ""; echo ""; $pts_check = $row_m_g["pts"]; } echo "
Rank  Name, School".$row_sched["eventshort"]."Top Pts. 2nd Pts. 3rd Pts. Ttl. Pts. 
 ".$rank.".  ".$row_m_g["first"]." ".$row_m_g["last"].", ".$row_m_g["team"]."— DQ(".$row_invite["dq"].") DNS(".$row_invite["dns"].") DNF(".$row_invite["dnf"].") ".$row_invite["indvpts"]." ".$row_m_g["res1"]." ".$row_m_g["res2"]." ".$row_m_g["res3"]." ".$row_m_g["pts"]." 

"; echo ""; include('/var/www/vhosts/rmisaskiing.com/httpdocs/library/footer.php'); ?>