Changeset 8123 for trunk/MagicSoft/Mars/datacenter/db/printtable.php

Timestamp:

10/18/06 19:10:02 (18 years ago)

Author:

Daniela Dorner

Message:

*** empty log message ***

File:

• trunk/MagicSoft/Mars/datacenter/db/printtable.php (modified) (1 diff)

trunk/MagicSoft/Mars/datacenter/db/printtable.php

@@ -27 +27 @@
         mysql_select_db($db);
 
-        $query0  = "SELECT * FROM ";
-        $query0 .= $_GET["fTable"];
+        $fromtable=$_GET["fTable"];
+        $query0  = "SELECT * FROM " . $fromtable;
+        if (!empty($_GET["fSortBy"]))
+        {
+            $val=substr($_GET["fSortBy"], 0, -1);
+            $query0 .= " ORDER BY " . GetTable($fromtable,$val) . " ";
+            if (substr($_GET["fSortBy"], -1)=="-")
+                $query0 .= "DESC";
+        }
+
 
         $result0 = mysql_query($query0, $db_id);