include ("mysqlLS.inc")?>
Fussballweltmeisterschaften
Tore der WM`s
Tore (ohne Elfmeterschiessen) erzielt:
echo "";
echo "| Jahr | ";
echo "Tore | ";
echo "Spiele | ";
echo "DS | ";
echo "
";
$jahr = array( "1930", "1934", "1938", "1950", "1954", "1958", "1962", "1966", "1970", "1974", "1978", "1982", "1986", "1990", "1994", "1998", "2002", "2006", "2010");
for ($x = 0; $x < 19; $x++){
$jg[$x] = $jahr[$x];
}
for ($x = 0; $x < 19; $x++){
// ---------------------------------------------------------------------
$sql = mysql_query("SELECT * FROM fwm WHERE jahr LIKE '%$jg[$x]%';");
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;
$tg[$x] = $tg[$x] + $t1 + $t2;
$z[$x] = $z[$x] + 1;
$d[$x] = $tg[$x] / $z[$x];
//--------------------------------------
$durch[$x] = substr($d[$x], 0, 4);
//-----------------------------------------
}
}
mysql_close($dz);
for ($x = 0; $x < 19; $x++){
echo "";
echo "| $jg[$x] | ";
echo "$tg[$x] | ";
echo "$z[$x] | ";
echo "$durch[$x] | ";
echo "
";
$tges = $tges + $tg[$x];
$zges = $zges + $z[$x];
$dges = $tges / $zges;
$duges = substr($dges, 0, 4);
}
$text1 = "Gesamt";
echo "";
echo "| $text1 | ";
echo "$tges | ";
echo "$zges | ";
echo "$duges | ";
echo "
";
?>