include ("mysqlLS.inc")?>
Torschützen 2012
Torschützen EM 2012 - Stand: 22.06.12 - 13.oo Uhr
Bitte Sortierung auswählen !
$stimme = $ausw[$_POST['frage']];
$wahl = array( "name", "land", "tore");
$auswahl = $wahl[$_POST['frage']];
$mann = array ("Ukraine", "Polen", "Deutschland", "Kroatien", "Irland", "Portugal", "Dänemark", "Tschechien", "Holland", "Italien", "Frankreich", "England", "Russland", "Spanien", "Schweden", "Griechenland");
for ($k = 0; $k < 17; $k++){
$land[$k] = $mann[$k];
}
$s = array (3, 3, 5, 3, 3, 5, 3, 4, 3, 5, 4, 4, 3, 5, 3, 4);
for ($k = 0; $k < 17; $k++){
$sp[$k] = $s[$k];
}
?>
echo "";
echo "| Name | ";
echo "Land | ";
echo "Tore | ";
echo "Elfm | ";
echo "
";
$sql = mysql_query("SELECT * FROM torsch2012 ORDER BY land;");
while ($ds = mysql_fetch_object($sql)){
$name = $ds -> name;
$land = $ds -> land;
$tor = $ds -> tore;
$elf = $ds -> elf;
if ($land === $mann[0]){
?>
}
if ($land === $mann[1]){
?>
}
if ($land === $mann[2]){
?>
}
if ($land === $mann[3]){
?>
}
if ($land === $mann[4]){
?>
}
if ($land === $mann[5]){
?>
}
if ($land === $mann[6]){
?>
}
if ($land === $mann[7]){
?>
}
if ($land === $mann[8]){
?>
}
if ($land === $mann[9]){
?>
}
if ($land === $mann[10]){
?>
}
if ($land === $mann[11]){
?>
}
if ($land === $mann[12]){
?>
}
if ($land === $mann[13]){
?>
}
if ($land === $mann[14]){
?>
}
if ($land === $mann[15]){
?>
}
echo "| $name | ";
echo "$land | ";
echo "$tor | ";
if ($elf <> 0){
?>
echo $elf;?> |
}
echo "
";
}
?>
echo "";
echo "| Name | ";
echo "Land | ";
echo "Tore | ";
echo "Elfm | ";
echo "
";
if ($auswahl === "tore"){
$sql = mysql_query("SELECT * FROM torsch2012 ORDER BY tore DESC;");
}
if ($auswahl === "name"){
$sql = mysql_query("SELECT * FROM torsch2012 ORDER BY name;");
}
if ($auswahl === "land"){
$sql = mysql_query("SELECT * FROM torsch2012 ORDER BY land;");
}
while ($ds = mysql_fetch_object($sql)){
$name = $ds -> name;
$land = $ds -> land;
$tor = $ds -> tore;
$elf = $ds -> elf;
if ($land === $mann[0]){
$t[0] = $t[0] + $tor;
?>
}
if ($land === $mann[1]){
$t[1] = $t[1] + $tor;
?>
}
if ($land === $mann[2]){
$t[2] = $t[2] + $tor;
?>
}
if ($land === $mann[3]){
$t[3] = $t[3] + $tor;
?>
}
if ($land === $mann[4]){
$t[4] = $t[4] + $tor;
?>
}
if ($land === $mann[5]){
$t[5] = $t[5] + $tor;
?>
}
if ($land === $mann[6]){
$t[6] = $t[6] + $tor;
?>
}
if ($land === $mann[7]){
$t[7] = $t[7] + $tor;
?>
}
if ($land === $mann[8]){
$t[8] = $t[8] + $tor;
?>
}
if ($land === $mann[9]){
$t[9] = $t[9] + $tor;
?>
}
if ($land === $mann[10]){
$t[10] = $t[10] + $tor;
?>
}
if ($land === $mann[11]){
$t[11] = $t[11] + $tor;
?>
}
if ($land === $mann[12]){
$t[12] = $t[12] + $tor;
?>
}
if ($land === $mann[13]){
$t[13] = $t[13] + $tor;
?>
}
if ($land === $mann[14]){
$t[14] = $t[14] + $tor;
?>
}
if ($land === $mann[15]){
$t[15] = $t[15] + $tor;
?>
}
echo "| $name | ";
echo "$land | ";
echo "$tor | ";
if ($elf <> 0){
?>
echo $elf;?> |
}
echo "
";
}
mysql_close($dz);
?>
echo "";
echo "| Land | ";
echo "T | ";
echo "Sp | ";
echo "DS | ";
echo "
";
echo "";
for ($n = 0; $n < 16; $n++){
echo "| $mann[$n] | ";
echo "$t[$n] | ";
echo "$sp[$n] | ";
$d[$n] = $t[$n] / $sp[$n];
if (strlen($d[$n]) < 2){
$d[$n] = "$d[$n]".".00";
}
$ds[$n] = substr($d[$n], 0, 4);
echo "$ds[$n] | ";
echo "
";
$tges = $tges + $t[$n];
$spges = $spges + $sp[$n];
}
$ds = ($tges / $spges) * 2;
$dsg = substr($ds, 0, 4);
$spg = $spges / 2;
?>
echo "| Gesamt | ";
echo "$tges | ";
echo "$spg | ";
echo "$dsg | ";
echo "
";
?>