Resultat från

Datum:25 aug 2005
Arrangör:Västerås FK och Blodcentralen
'00:00:00'::time order by (goaltime-starttime) limit $first"; $qres = pg_query($q); $qclass = "select classname from cl where classid=$class"; $resclass = pg_query($qclass); if($line = pg_fetch_array($resclass)) { echo "

".$line['classname']."

"; } $i=1; $firstline=1; while($line = pg_fetch_array($qres)) { if($firstline==1) { $firstline=0; echo "\n"; } if($prevres == $line['result']) { $place = ''; } else { $place = $i; } echo "\t\n\t\t\n\t"; $i++; $prevres = $line['result']; } if($i==1) echo "

Resultaten kommer senare under dagen

"; else echo "\n
" .$place. " " .htmlspecialchars($line['startnumber']) . " " .htmlspecialchars($line['fname']) ." " .htmlspecialchars($line['lname']). " " .htmlspecialchars($line['club']). " ".$line['result']. "
"; } ?>

Här kan du söka efter resultat samt ladda ner en filmsnutt av din målgång.

Sök på namn eller startnummer


".$cl_line['classname'].""; } ?>

Endast de 20 första träffarna visas.

"; } $res = pg_query($query); echo ""; echo ""; while($line = pg_fetch_array($res)) { if($line['cmptime'] != '') { $query_p = "select count(*)+1 from runner where classid=".$line['classid']." and (goaltime-starttime)::interval(0)<'".$line['cmptime']."' and goaltime is not null and starttime is not null and (goaltime-starttime)::interval>'00:00:00'::interval"; $res_p = pg_query($query_p); $line_p = pg_fetch_array($res_p); $place = $line_p[0]; } else { $place = ''; } echo ""; } echo "
Klass Placering Startnr Namn Stad Tid Se målgångsvideo
".$line['classname']." ".$line_p[0]." ".$line['startnumber']." ".$line['name']." ".$line['club']." ".$line['time']." "; $filename = $dbname."_2005_nr".$line['startnumber'].".mpg"; $filepath = "videos/bo-vasteras-2005/".$filename; $abspath = $_SERVER["DOCUMENT_ROOT"]."/".$filepath; if(file_exists($abspath)) { echo "$filename"; } echo "
"; } else if(isset($_GET['class'])) { listres($dbconn,2000000,$_GET['class']); } ?>

Ser du felaktigheter i resultatlistan? Skicka i så fall ett mail till racetimer@nol.se eller ring 0705-546941.