include ("mysqlLS.inc")?>
Fussballeuropameisterschaften
Europameisterschaft 1976 Jugoslawien 4 Teilnehmer Europameister CSSR
$jahr = "1976";
$anh = array( "1", "2", "3", "4", " A", " B", " C", " D" );
for ($x = 0; $x < 2; $x++){
$gruppe[$x] = "Gr"."$anh[$x]";
}
//------------------------------------------------------------------
?>
echo "";
echo "| Datum | ";
echo "Spielort | ";
echo "Heim | ";
echo "Gast | ";
echo "Erg | ";
echo "Art | ";
echo "
";
$sql = mysql_query("SELECT * FROM emvf WHERE bem = $jahr;");
while ($ds = mysql_fetch_object($sql)){
$dat = $ds -> dat;
$ort = $ds -> ort;
$heim = $ds -> heim;
$gast = $ds -> gast;
$ee = $ds -> ee;
$tpl = $ds -> tpl;
$tmin = $ds -> tmin;
$art = $ds -> art;
$bem = $ds -> bem;
$bem2 = $ds -> bem2;
$za = $za + 1;
$rest = $za % 2;
if ($rest === 0){
?>
}
if ($rest === 1){
?>
}
echo "| $dat";
echo " | $ort";
echo " | $heim";
echo " | $gast";
echo " | $ee";
switch ($bem2) {
case "0":
echo " | ."; break;
case "":
echo " | ."; break;
default:
echo " | $bem2";
}
$text10 = "Viertelfinals in Hin- und Rückspielen";
if ($za == "3"){
echo " | $text10";
}
}
echo " |
";
?>
//-----------------------------------------------------------------
$hf = "HF";
$pl = "Pl";
$fin = "Fin";
$sql = mysql_query("SELECT * FROM euro WHERE jahr LIKE '%$jahr%' AND (gr LIKE '%$hf%' OR gr LIKE '%$fin%' OR gr LIKE '%$pl%');");
while ($ds = mysql_fetch_object($sql)){
$spnr = $ds -> spnr;
$jahr = $ds -> jahr;
$land = $ds -> land;
$gr = $ds -> gr;
$m1 = $ds -> m1;
$m2 = $ds -> m2;
$t1 = $ds -> t1;
$t2 = $ds -> t2;
$bes = $ds -> bes;
switch ($bes) {
case "x":
$bes = " ";
break;
default:
$bes = $bes;
}
$text = "$m1"." - "."$m2"." "."$t1".":"."$t2"." "."$bes";
if ($spnr === "18"){
$thf1 = "Halbfinale 1";
?>
}
if ($spnr === "19"){
$thf2 = "Halbfinale 2";
?>
}
if ($spnr === "20"){
$thf2 = "Spiel um Platz 3";
?>
}
if ($spnr === "21"){
$tfin = "Finale";
?>
}
}
//-----------------------------------------------------------------
mysql_close($dz);
echo "";
?>
for ($c = 0; $c < 22; $c++){
echo "
";
}
?>