include ("mysqlLS.inc")?>
Fussballeuropameisterschaften
Europameisterschaft 1992 Schweden 8 Teilnehmer Europameister Dänemark
$jahr = "1992";
$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 === "78"){
$thf1 = "Halbfinale 1";
?>
}
if ($spnr === "79"){
$thf2 = "Halbfinale 2";
?>
}
if ($spnr === "80"){
$tfin = "Finale";
?>
}
}
//-----------------------------------------------------------------
mysql_close($dz);
echo "";
?>
|
|
|
|
| 1. |
Schweden |
5 |
4:2 |
| 2. |
Dänemark |
3 |
2:2 |
| 3. |
Frankreich |
2 |
2:3 |
| 4. |
England |
2 |
1:2 |
|
|
|
|
| 1. |
Holland |
5 |
4:1 |
| 2. |
Deutschland |
3 |
4:4 |
| 3. |
Schottland |
2 |
3:3 |
| 4. |
GUS |
2 |
1:4 |
for ($c = 0; $c < 29; $c++){
echo "
";
}
?>