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" .$place. " |
" .htmlspecialchars($line['startnumber']) . " |
" .htmlspecialchars($line['fname']) ." " .htmlspecialchars($line['lname']). " |
" .htmlspecialchars($line['club']). " |
".$line['result']. " | \n\t
";
$i++;
$prevres = $line['result'];
}
if($i==1) echo "Resultaten kommer senare under dagen
";
else echo "\n
";
}
?>
".$cl_line['classname']."";
}
?>
Endast de 20 första träffarna visas.";
}
$res = pg_query($query);
echo "";
echo "
Klass |
Placering |
Startnr |
Namn |
Stad |
Tid |
Se målgångsvideo |
";
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 "
".$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 " |
";
}
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.