Resultat från

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

'00:00:00'::time order by (goaltime-cl.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"; echo "\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']. ""; $filename = $videofilename."_nr".$line['startnumber'].".mpg"; $filepath = "/videos/".$videofilename."/".$filename; $abspath = $_SERVER["DOCUMENT_ROOT"] . $filepath; if(file_exists($abspath)) { echo "Målgångsvideo"; } echo "
"; } if(isset($_GET['class'])) { listres($dbconn,2000000,$_GET['class']); } ?>