diff options
Diffstat (limited to 'www-ssl/admin/debug.php')
| -rwxr-xr-x | www-ssl/admin/debug.php | 37 |
1 files changed, 15 insertions, 22 deletions
diff --git a/www-ssl/admin/debug.php b/www-ssl/admin/debug.php index afc394eb..af42dd20 100755 --- a/www-ssl/admin/debug.php +++ b/www-ssl/admin/debug.php @@ -30,33 +30,26 @@ funktion_db_list("FAQ"); echo "Deaktiviert"; */ +echo "<br>\n"; +funktion_db_element_list_2row( "Tshirt-Size aller engel", + "SELECT `Size`, COUNT(`Size`) FROM `User` GROUP BY `Size`"); -echo "<h1>Tshirt-Size aller engel</h1>"; -$SQL="SELECT `Size`, COUNT(`Size`) FROM `User` GROUP BY `Size`"; -$Erg = mysql_query($SQL, $con); -echo mysql_error($con); -$rowcount = mysql_num_rows($Erg); +echo "<br>\n"; +funktion_db_element_list_2row( "Tshirt ausgegeben", + "SELECT `Size`, COUNT(`Size`) FROM `User` WHERE `Tshirt`='1' GROUP BY `Size`"); -for ($i=0; $i<$rowcount; $i++) - echo mysql_result($Erg, $i, 1). "x '". mysql_result($Erg, $i, 0). "'<br>\n"; +echo "<br>\n"; +funktion_db_element_list_2row( "Tshirt nicht ausgegeben (Gekommen=1)", + "SELECT COUNT(`Size`), `Size` FROM `User` WHERE `Gekommen`='1' and `Tshirt`='0' GROUP BY `Size`"); -echo "<h1>Tshirt ausgegeben</h1>"; -$SQL="SELECT `Size`, COUNT(`Size`) FROM `User` WHERE `Tshirt`='1' GROUP BY `Size`"; -$Erg = mysql_query($SQL, $con); -echo mysql_error($con); -$rowcount = mysql_num_rows($Erg); +echo "<br>\n"; +funktion_db_element_list_2row( "Hometown", + "SELECT COUNT(`Hometown`), `Hometown` FROM `User` GROUP BY `Hometown`"); -for ($i=0; $i<$rowcount; $i++) - echo mysql_result($Erg, $i, 1). "x '". mysql_result($Erg, $i, 0). "'<br>\n"; +echo "<br>\n"; +funktion_db_element_list_2row( "Engeltypen", + "SELECT COUNT(`Art`), `Art` FROM `User` GROUP BY `Art`"); -echo "<h1>Tshirt nicht ausgegeben (Gekommen=1)</h1>"; -$SQL="SELECT `Size`, COUNT(`Size`) FROM `User` WHERE `Gekommen`='1' and `Tshirt`='0' GROUP BY `Size`"; -$Erg = mysql_query($SQL, $con); -echo mysql_error($con); -$rowcount = mysql_num_rows($Erg); - -for ($i=0; $i<$rowcount; $i++) - echo mysql_result($Erg, $i, 1). "x '". mysql_result($Erg, $i, 0). "'<br>\n"; include ("../../includes/footer.php"); ?> |