LIVE RESULTS

Splits available at SportStats.us
"; echo "

".$row_race_info["season"]." ".$row_race_info["longname"]."

"; echo "

".$row_race_info["racename"]."

"; ?>

FULL RESULTS:

Start Time"; } ?> "; if($row_race2["totalrank"]) { echo ""; } else { echo ""; } echo ""; echo ""; echo ""; if($starttype == 'I') { $starttime = date("g:i:s A",strtotime($row_race2["starttime"])); echo ""; } if($row_race2["totaltime"]) { if ($row_race2["totaltime"] >= 3600) { $h = floor($row_race2["totaltime"] / 3600); $m = floor(($row_race2["totaltime"] / 60) % 60); $s = $row_race2["totaltime"] % 60; $fl = substr($row_race2["totaltime"], -1, 1); if($h == 0) { if ($s < 10) { echo ""; } else { echo ""; } } else { if($m < 10) { if($s < 10) { echo ""; } else { echo ""; } } else { if($s < 10) { echo ""; } else { echo ""; } } } } else { $m = floor(($row_race2["totaltime"] / 60) % 60); $s = $row_race2["totaltime"] % 60; if ($discipline == "a") { $fl = substr($row_race2["totaltime"], -2, 2); } else { $fl = substr($row_race2["totaltime"], -1, 1); } if ($s < 10) { echo ""; } else { echo ""; } } } else { echo ""; } if(is_null($row_race2["teampts"])) { echo ""; } else { echo ""; } echo ""; } $query_dnf = "select * from liven where raceid = '".$rid."' and dnf = 'y' order by bib"; $result_dnf = mysql_query($query_dnf); $num_results_dnf = mysql_num_rows($result_dnf); if( $num_results_dnf > 0) { echo ""; echo ""; echo ""; for ($i_dnf=0; $i_dnf < $num_results_dnf; $i_dnf++) { $row_dnf = mysql_fetch_array($result_dnf); echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } } ?>
Rank Bib Name School Total
Time		 Team
Points
".$row_race2["totalrank"].".  ".$row_race2["bib"]."".$row_race2["firstname"]." ".$row_race2["lastname"]."".$row_race2["teamshort"]."".$starttime."".$m.":0".$s.".".$fl."".$m.":".$s.".".$fl."".$h.":0".$m.":0".$s.".".$fl."".$h.":0".$m.":".$s.".".$fl."".$h.":".$m.":0".$s.".".$fl."".$h.":".$m.":".$s.".".$fl."".$m.":0".$s.".".$fl."".$m.":".$s.".".$fl."  ".$row_race2["teampts"]."
DID NOT FINISH
 ".$row_dnf["bib"]."".$row_dnf["firstname"]." ".$row_dnf["lastname"]."".$row_dnf["teamshort"]." 
"; echo " "; echo "
"; echo "
"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; $score_check = 0; $query_score = "select sum(teampts) as points, teamshort from liven where raceid = '".$rid."' group by teamid order by points desc, teamshort"; $result_score = mysql_query($query_score); $num_results_score = mysql_num_rows($result_score); for ($i_score=0; $i_score < $num_results_score; $i_score++) { $ts_rank = $i_score + 1; $row_score = mysql_fetch_array($result_score); echo ""; if($score_check == $row_score["points"]) { echo ""; } else { echo ""; } echo ""; echo ""; echo ""; $score_check = $row_score["points"]; } echo ""; echo "
RkTeamScore
 ".$ts_rank.". ".$row_score["teamshort"]."".$row_score["points"]."
"; echo "
"; echo "
"; echo "
"; } ?>