Resultat från
'00:00:00'::time(0) order by goaltime-cl.starttime";
$qres = pg_query($q);
$i=1;
//echo "Namn | Företag / Lagnamn | Nr |
";
$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']). " |
".htmlspecialchars($line['teamname']). " |
".$line['result']. " | \n\t
";
$i++;
$prevres = $line['result'];
}
if($i<2) echo "Resultaten kommer senare under dagen
";
else echo "\n
";
}
?>
Hittar du inte ditt resultat? Hör av dig till oss via epost: resultat@racetimer.se
eller via telefon: 08-559 242 45 / 070-554 69 41.
Herrar 10 km
Damer 10 km
Herrar 5 km
Damer 5 km
cl.starttime";
}
else {
$array = explode(' ',$s);
$where = " where (goaltime is not null and goaltime>cl.starttime) ";
for($i=0;$i";
echo "Placering |
Startnr |
Namn |
Företag/Förening |
Tid |
Se målgångsvideo |
";
while($line = pg_fetch_array($res)) {
$query_p = "select count(*)+1 from runner join cl on runner.classid=cl.classid where runner.classid=".$line['classid']." and (goaltime-cl.starttime)<'".$line['cmptime']."' and goaltime is not null and (goaltime-cl.starttime)>'00:00:00'::interval";
$res_p = pg_query($query_p);
$line_p = pg_fetch_array($res_p);
echo "".$line_p[0]." |
".$line['startnumber']." |
".$line['name']." |
".$line['club']." |
".$line['time']." |
";
$filename = $video_prefix."_nr".$line['startnumber'].".mpg";
$filepath = "videos/".$video_prefix."/".$filename;
$abspath = $_SERVER["DOCUMENT_ROOT"]."/".$filepath;
if(file_exists($abspath)) {
echo "$filename";
}
echo " |
";
}
echo "";
}
else if(isset($_GET['class'])) {
listres($dbconn,$_GET['class']);
}
?>