Resultat från Blodomloppet i Linköping 2005

Datum:2 juni 2005
Arrangör:IK Akele och Blodtappen
'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


Herrar 10 km Damer 10 km Herrar 5 km Damer 5 km

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 = "bo_linkoping_2005_nr".$line['startnumber'].".mpg"; $filepath = "videos/bo-linkoping-2005/".$filename; $abspath = $_SERVER["DOCUMENT_ROOT"]."/".$filepath; if(file_exists($abspath)) { echo "$filename"; } echo "
"; } else if(isset($_GET['class'])) { listres($dbconn,2000000,$_GET['class']); } ?>