Resultat från Grabbhalvan i Norrköping 2005

Datum:12 maj 2005
Arrangör:Norrköpings Friidrottsklubb
='00:05:00'::time(0) order by result limit $first"; $qres = pg_query($q); $i=1; //echo "NamnFöretag / LagnamnNr"; $firstline=1; while($line = pg_fetch_array($qres)) { if($firstline==1) { $firstline=0; echo "\n"; } echo "\t\n\t\t\n\t"; $i++; } if($i<2) echo "

Resultaten kommer senare under dagen

"; else echo "\n
" .$i. " " .htmlspecialchars($line['startnumber']) . " " .htmlspecialchars($line['fname']) ." " .htmlspecialchars($line['lname']). " " .htmlspecialchars($line['club']). " ".htmlspecialchars($line['teamname']). " ".$line['result']. "
"; } function listres_lag($con,$first){ $q = "select * from (select min(teamname) as teamname,min(club) as club, ltrim(sum(goaltime-starttime)::time(0)::varchar,'0:') as time,count(goaltime) as ant from runner natural left join team where runner.teamid<>0 group by runner.teamid order by sum(goaltime-starttime)) as a where ant=5;"; $qres = pg_query($q); $i=1; //echo "NamnFöretag / LagnamnNr"; $firstline=1; while($line = pg_fetch_array($qres)) { if($firstline==1) { $firstline=0; echo "\n"; } echo "\t\n\t\t\n\t"; $i++; } if($i<2) echo "

Resultaten kommer senare under dagen

"; else echo "\n
" .$i. " " .htmlspecialchars($line['teamname']) ." " .htmlspecialchars($line['club']). " ".$line['time']. "
"; } ?>

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

Sök på namn, företag/förening, lagnamn eller startnummer


Top 200 Lagresultat Fullständig resultatlista

"; $query; if(is_numeric($s)) { $query = "select startnumber,fname||' '||lname as name,club,teamname, ltrim((goaltime-starttime)::time(0)::varchar,'0:') as time, goaltime-starttime as cmptime from runner natural join team where startnumber=$s and goaltime is not null and starttime is not null"; } else { $array = explode(' ',$s); $where = " where goaltime is not null and starttime is not null "; 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 where goaltime-starttime<'".$line['cmptime']."' and goaltime is not null and starttime is not null and goaltime-starttime>0"; $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 = "gh_nkpg_2005_nr".$line['startnumber'].".mpg"; $filepath = "videos/nkpg-2005/".$filename; $abspath = $_SERVER["DOCUMENT_ROOT"]."/".$filepath; if(file_exists($abspath)) { echo "$filename"; } echo " "; } echo ""; } else if($_GET['res'] == "lag") { echo "

Top 200 Lagresultat Fullständig resultatlista

"; listres_lag($dbconn,200); } else if($_GET['res'] == "ind") { echo "

Top 200 Lagresultat Fullständig resultatlista

"; listres($dbconn,2000000); } else { echo "

Top 200 Lagresultat Fullständig resultatlista

"; listres($dbconn,200); } ?>