include ("mysqlLS.inc")?>
Fussballeuropameisterschaften
Europameisterschaft 1984 Frankreich 8 Teilnehmer Europameister Frankreich
$jahr = "1984";
$anh = array( "1", "2", "3", "4", " A", " B", " C", " D" );
for ($x = 0; $x < 2; $x++){
$gruppe[$x] = "Gr"."$anh[$x]";
}
for ($zae = 0; $zae < 2; $zae++){
$sql = mysql_query("SELECT * FROM euro WHERE jahr LIKE '%$jahr%' AND gr LIKE '%$gruppe[$zae]%';");
if ($zae === 0){
?>
}
if ($zae === 1){
?>
}
?>
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;
echo "";
switch ($gr) {
case "Gr1":
?>
break;
case "Gr2":
?>
break;
default:
echo "$gr";
}
echo " $m1"." - "."$m2"." ";
echo " $t1".":"."$t2";
echo " ";
}
?>
}
//-----------------------------------------------------------------
$hf = "HF";
$fin = "Fin";
$sql = mysql_query("SELECT * FROM euro WHERE jahr LIKE '%$jahr%' AND (gr LIKE '%$hf%' OR gr LIKE '%$fin%');");
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 === "48"){
$thf1 = "Halbfinale 1";
?>
}
if ($spnr === "49"){
$thf2 = "Halbfinale 2";
?>
}
if ($spnr === "50"){
$tfin = "Finale";
?>
}
}
//-----------------------------------------------------------------
mysql_close($dz);
echo "";
?>
1.
Frankreich
6
9:2
2.
Dänemark
4
8:3
3.
Belgien
2
4:8
4.
Jugoslawien
0
2:10
1.
Spanien
4
3:2
2.
Portugal
4
2:1
3.
Deutschland
3
2:2
4.
Rumänien
1
2:4
for ($c = 0; $c < 29; $c++){
echo "
";
}
?>