$hauf = array (0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);
$ergebnis = array ("1:0","2:0","2:1","3:0","3:1","3:2","4:0","4:1","4:2","4:3","5:0","5:1","5:2","5:3","5:4","6:0","6:1","6:2","7:0","7:1","7:2","8:0","8:1","8:2","9:0","9:1","9:3","12:0","13:0","16:0");
$sql = mysql_query("SELECT * FROM spiele WHERE pkt = 3;"); // S I E G E
while ($ds = mysql_fetch_object($sql)){
$heim = $ds -> heim;
$gast = $ds -> gast;
$ee = $ds -> ee;
$he = $ds -> he;
$pkt = $ds -> pkt;
$tpl = $ds -> tpl;
$tmin = $ds -> tmin;
$nr = $ds -> nr;
$art = $ds -> art;
$bem= $ds -> bem;
$bem2 = $ds -> bem2;
if ($tpl === "1" AND $tmin === "0") { // ............. 1:0
$hauf[0] = $hauf[0] + 1;
}
if ($tpl === "2" AND $tmin === "0") { //.............. 2:0
$hauf[1] = $hauf[1] + 1;
}
if ($tpl === "2" AND $tmin === "1") { //.............. 2:1
$hauf[2] = $hauf[2] + 1;
}
if ($tpl === "3" AND $tmin === "0") { //.............. 3:0
$hauf[3] = $hauf[3] + 1;
}
if ($tpl === "3" AND $tmin === "1") { //.............. 3:1
$hauf[4] = $hauf[4] + 1;
}
if ($tpl === "3" AND $tmin === "2") { //.............. 3:2
$hauf[5] = $hauf[5] + 1;
}
if ($tpl === "4" AND $tmin === "0") { //.............. 4:0
$hauf[6] = $hauf[6] + 1;
}
if ($tpl === "4" AND $tmin === "1") { //.............. 4:1
$hauf[7] = $hauf[7] + 1;
}
if ($tpl === "4" AND $tmin === "2") { //.............. 4:2
$hauf[8] = $hauf[8] + 1;
}
if ($tpl === "4" AND $tmin === "3") { //.............. 4:3
$hauf[9] = $hauf[9] + 1;
}
if ($tpl === "5" AND $tmin === "0") { //.............. 5:0
$hauf[10] = $hauf[10] + 1;
}
if ($tpl === "5" AND $tmin === "1") { //.............. 5:1
$hauf[11] = $hauf[11] + 1;
}
if ($tpl === "5" AND $tmin === "2") { //.............. 5:2
$hauf[12] = $hauf[12] + 1;
}
if ($tpl === "5" AND $tmin === "3") { //.............. 5:3
$hauf[13] = $hauf[13] + 1;
}
if ($tpl === "5" AND $tmin === "4") { //.............. 5:4
$hauf[14] = $hauf[14] + 1;
}
if ($tpl === "6" AND $tmin === "0") { //.............. 6:0
$hauf[15] = $hauf[15] + 1;
}
if ($tpl === "6" AND $tmin === "1") { //.............. 6:1
$hauf[16] = $hauf[16] + 1;
}
if ($tpl === "6" AND $tmin === "2") { //.............. 6:2
$hauf[17] = $hauf[17] + 1;
}
if ($tpl === "7" AND $tmin === "0") { //.............. 7:0
$hauf[18] = $hauf[18] + 1;
}
if ($tpl === "7" AND $tmin === "1") { //.............. 7:1
$hauf[19] = $hauf[19] + 1;
}
if ($tpl === "7" AND $tmin === "2") { //.............. 7:2
$hauf[20] = $hauf[20] + 1;
}
if ($tpl === "8" AND $tmin === "0") { //.............. 8:0
$hauf[21] = $hauf[21] + 1;
}
if ($tpl === "8" AND $tmin === "1") { //.............. 8:1
$hauf[22] = $hauf[22] + 1;
}
if ($tpl === "8" AND $tmin === "2") { //.............. 8:2
$hauf[23] = $hauf[23] + 1;
}
if ($tpl === "9" AND $tmin === "0") { //.............. 9:0
$hauf[24] = $hauf[24] + 1;
}
if ($tpl === "9" AND $tmin === "1") { //.............. 9:1
$hauf[25] = $hauf[25] + 1;
}
if ($tpl === "9" AND $tmin === "3") { //.............. 9:3
$hauf[26] = $hauf[26] + 1;
}
if ($tpl === "12" AND $tmin === "0") { //.............. 12:0
$hauf[27] = $hauf[27] + 1;
}
if ($tpl === "13" AND $tmin === "0") { //.............. 13:0
$hauf[28] = $hauf[28] + 1;
}
if ($tpl === "16" AND $tmin === "0") { //.............. 16:0
$hauf[29] = $hauf[29] + 1;
}
}
// ................. Ende SQL ...................................
?>
| Erg |
Anz |
Darstellung |
for ($x = 0; $x < 30; $x++){
$sterne[$x] = str_repeat("_", $hauf[$x]);
?>
|
|
|
}
mysql_close($dz);
?>