include ("mysqlLS.inc")?>
Kombionierte Abfrage
Möglichkeit: Trainer- und Länderabfrage
Ohne Eingabe des Landes erscheinen alle Spiele des Trainers und der Name der letzten Mannschaft.
Ohne Eingabe des Trainers erscheinen alle Spiele gegen die Mannschaft.
$ind = $_POST["feld1"]; $la = $_POST["feld2"]; $wahl = array( "N", "H", "S", "D", "B", "Vo", "R" , "Vl", "Kl", "Lw"); $na = $wahl[$ind]; ?>| Nr. | "; echo "Datum | "; echo "Spielort | "; echo "Heim | "; echo "Gast | "; echo "Erg | "; echo "HZ | "; echo "Art | "; echo "Bemerk | "; echo "||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| $nr"; echo " | $dat"; echo " | $ort"; echo " | $heim"; echo " | $gast"; if ($pkt ==3) { ?> | } if ($pkt ==0) { ?> | } if ($pkt ==1) { ?> | } echo " | $he"; if ($art == "WM_HF" or $art == "WM_F" or $art == "WM_PL") { ?> | } if ($art == "WM_VF" or $art == "WM_AF") { ?> | } if ($art == "WM_VR" or $art == "WM_ZR") { ?> | } if ($art == "WM-Q") { ?> | } if ($art == "FS") { ?> | } if ($art == "EM-Q") { ?> | } if ($art == "EM_VR") { ?> | } if ($art == "EM_AF" or $art == "EM_VF" or $art == "EM_HF") { ?> | } if ($art == "EM_F") { ?> | } if ($art == "OSP") { ?> | } if ($art == "N.Tur" or $art == "Mini-WM" or $art == "Confed" or $art == "Confed VR" or $art == "Confed HF" or $art == "Confed PL" or $art == "US-Cup") { ?> | } switch ($bem) { case "x": echo " | ."; break; case "": echo " | ."; break; default: echo " | $bem"; } $weiter = "http://www.lutzsiebert.de/htdocs/lsp/spielinfo.php?su=$nr"; ?> | ">INFO | echo ""; if ($pkt ==3) { $gew = $gew +1; } if ($pkt ==1) { $un = $un +1; } if ($pkt ==0) { $ver = $ver +1; } $z = $z+1; $tp = $tp + $tpl; $tm = $tm + $tmin; $gp = $gp + $pkt; $tore = "$tp".":"."$tm"; } $mann = $heim; if ($mann == "Deutschland") { $mann = $gast; } mysql_close($dz); $land = $mann; echo " |
| Sp | ge | un | ve | Tore | Pkt |
|---|