From 0059fd16dd903abc5417e3f4c8c6a9c1fdb3ab26 Mon Sep 17 00:00:00 2001
From: Angelo Cuccato <cuccato@web.de>
Date: Mon, 8 Nov 2010 23:38:31 +0100
Subject: add Statistics

---
 includes/funktion_db_list.php | 72 +++++++++++++++++++++++++++++++------------
 1 file changed, 52 insertions(+), 20 deletions(-)

(limited to 'includes/funktion_db_list.php')

diff --git a/includes/funktion_db_list.php b/includes/funktion_db_list.php
index fbf1c821..8b64297e 100755
--- a/includes/funktion_db_list.php
+++ b/includes/funktion_db_list.php
@@ -1,34 +1,66 @@
 <?PHP
 
-function funktion_db_list($Table_Name) {
-
+function funktion_db_list($Table_Name) 
+{
 	global $con;
 
-$SQL = "SELECT * FROM `".$Table_Name."`";
-$Erg = mysql_query($SQL, $con);
+	$SQL = "SELECT * FROM `".$Table_Name."`";
+	$Erg = mysql_query($SQL, $con);
 
-// anzahl zeilen
-$Zeilen  = mysql_num_rows($Erg);
+	// anzahl zeilen
+	$Zeilen  = mysql_num_rows($Erg);
 
-$Anzahl_Felder = mysql_num_fields($Erg);
+	$Anzahl_Felder = mysql_num_fields($Erg);
 
-echo "<table border=1>";
+	echo "<table border=1>";
 
-echo "<tr>";
-for ($m = 0 ; $m < $Anzahl_Felder ; $m++) {
-  echo "<th>". mysql_field_name($Erg, $m). "</th>";
-  }
-echo "</tr>";
+	echo "<tr>";
+	for ($m = 0 ; $m < $Anzahl_Felder ; $m++)
+	{
+		echo "<th>". mysql_field_name($Erg, $m). "</th>";
+	}
+	echo "</tr>";
 
-for ($n = 0 ; $n < $Zeilen ; $n++) {
-  echo "<tr>";
-  for ($m = 0 ; $m < $Anzahl_Felder ; $m++) {
-    echo "<td>".mysql_result($Erg, $n, $m). "</td>"; 
-  }
-  echo "</tr>";
+	for ($n = 0 ; $n < $Zeilen ; $n++)
+	{
+		echo "<tr>";
+		for ($m = 0 ; $m < $Anzahl_Felder ; $m++)
+		{
+			echo "<td>".mysql_result($Erg, $n, $m). "</td>"; 
+		}
+		echo "</tr>";
+	}
+	echo "</table>";
 }
 
-echo "</table>";
+function funktion_db_element_list_2row( $TopicName, $SQL) 
+{
+	global $con;
+
+	echo "<table class=\"border\" cellpadding=\"2\" cellspacing=\"1\">\n";
+	echo "<caption>$TopicName</caption>";
+#	echo "\t<tr class=\"contenttopic\"> <td><h1>$TopicName</h1></td> </tr>\n";
+
+	$Erg = mysql_query($SQL, $con);
+	echo mysql_error($con);
+	
+	echo "<tr  class=\"contenttopic\">";
+	for ($m = 0 ; $m < mysql_num_fields($Erg) ; $m++)
+	{
+		echo "<th>". mysql_field_name($Erg, $m). "</th>";
+	}
+	echo "</tr>";
+
+	for ($n = 0 ; $n < mysql_num_rows($Erg) ; $n++)
+	{
+		echo "<tr class=\"content\">";
+		for ($m = 0 ; $m < mysql_num_fields($Erg) ; $m++)
+		{
+			echo "<td>".mysql_result($Erg, $n, $m). "</td>"; 
+		}
+		echo "</tr>";
+	}
+	echo "</table>\n";
 }
 
 ?>
-- 
cgit v1.2.3-70-g09d2