Länderspielbilanz

Bilanz weiss - positiv, gelb - negativ, ocker - ausgeglichen

Zur weiteren Info auf die Landesfahne klicken !

"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; //--------------------- Schleife über Länder for ($k = 0; $k < 91; $k++) { $sql = mysql_query("SELECT * FROM spiele WHERE heim LIKE '%$auswahl2[$k]%' OR gast LIKE '%$auswahl2[$k]%';"); while ($ds = mysql_fetch_object($sql)){ $heim = $ds -> heim; $gast = $ds -> gast; $ee = $ds -> ee; $he = $ds -> he; $pkt = $ds -> pkt; $tpl = $ds -> tpl; $tmin = $ds -> tmin; $nr = $ds -> nr; $art = $ds -> art; $bem= $ds -> bem; $bem2 = $ds -> bem2; //----------------- Umwandlung von ee ------------------------- $t1 = substr($ee, 0, 2); $t2 = substr($ee, 3, 2); $t11 = substr($t1, 0, 1); $t21 = substr($t2, 0, 1); if ($t11 === "0"){ $t1 = substr($ee, 1, 1); } else { $t1 = $t1; } if ($t21 === "0"){ $t2 = substr($ee, 4, 1); } else { $t2 = $t2; } $ee = "$t1".":"."$t2"; //----------------- Umwandlung von he ------------------------- $u1 = substr($he, 0, 2); $u2 = substr($he, 3, 2); $u11 = substr($u1, 0, 1); $u21 = substr($u2, 0, 1); if ($u11 === "0"){ $u1 = substr($he, 1, 1); } else { $u1 = $u1; } if ($u21 === "0"){ $u2 = substr($he, 4, 1); } else { $u2 = $u2; } $he = "$u1".":"."$u2"; //............................................................ if ($pkt ==3) { $gew[$k] = $gew[$k] +1; } if ($pkt ==1) { $un[$k] = $un[$k] +1; } if ($pkt ==0) { $ver[$k] = $ver[$k] +1; } $z[$k] = $z[$k] + 1; $tp[$k] = $tp[$k] + $tpl; $tm[$k] = $tm[$k] + $tmin; if ($art === "WM-Q"){ $wmq[$k] = $wmq[$k] + 1; } if ($art === "EM-Q"){ $emq[$k] = $emq[$k] + 1; } //--------------------------------------------- $test1 = substr($art, 0,3); //---------------------------------------------- if ($test1 === "EM_"){ $eme[$k] = $eme[$k] + 1; } if ($test1 === "WM_"){ $wme[$k] = $wme[$k] + 1; } //---------------------------------------------- $test2 = strpos($bem, "Elfm"); //----------------------------------------------- if ($test2 <> 0){ $elf[$k] = $elf[$k] + 1; } $land[$k] = $heim; if ($land[$k] == "Deutschland") { $land[$k] = $gast; } $tore[$k] = "$tp[$k]".":"."$tm[$k]"; } $spg = $spg + $z[$k]; $gewg = $gewg + $gew[$k]; $ung = $ung + $un[$k]; $verg = $verg + $ver[$k]; $tplg = $tplg + $tp[$k]; $tming = $tming + $tm[$k]; $tg = "$tplg".":"."$tming"; $wmqg = $wmqg + $wmq[$k]; $emqg = $emqg + $emq[$k]; $wmeg = $wmeg + $wme[$k]; $emeg = $emeg + $eme[$k]; $elfg = $elfg + $elf[$k]; } // -- Schleifenende ----------------------- mysql_close($dz); //-------------------- Ausgabenschleife for ($k = 0; $k < 90; $k++) { if ($wmq[$k] === 0) $wmq[$k] = "."; if ($wme[$k] === 0) $wme[$k] = "."; if ($emq[$k] === 0) $emq[$k] = "."; if ($eme[$k] === 0) $eme[$k] = "."; $rest = $k % 2; if ($rest === 0){ ?> $ver[$k]) { ?> $spg"; echo ""; ?> ."; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; ?>
LandSpguvToreWMQEMQWMEM11Spiele
Gesamt $gewg"; echo "$ung"; echo "$verg"; echo "$tg"; echo "$wmqg"; echo "$emqg"; echo "$wmeg"; echo "$emeg"; echo "$elfg"; echo "
SpguvToreWMQEMQWM-EREM-ER11

Die 7 Entscheidungen per Elfmeterschiessen wurden als Sieg für den Gewinner gewertet.