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

Timestamp:

08/20/09 14:43:59 (15 years ago)

Author:

Daniela Dorner

Message:

*** empty log message ***

File:

• trunk/MagicSoft/Mars/datacenter/db/printtable.php (modified) (4 diffs)

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

@@ -28 +28 @@
 
         $fromtable=$_GET["fTable"];
-        $query0  = "SELECT * FROM " . $fromtable;
+        $query0  = "SELECT SQL_CALC_FOUND_ROWS * FROM " . $fromtable;
         if (!empty($_GET["fSortBy"]))
         {
@@ -39 +39 @@
 
         $result0 = mysql_query($query0, $db_id);
+        $result1 = mysql_query("SELECT FOUND_ROWS()", $db_id);
 
         if ($result0)
@@ -50 +51 @@
                 (
                 );
-                PrintMagicTable($result0, $alias, $rightalign, "", "", "", "", $_GET);
+                PrintMagicTable($result0, $alias, $rightalign, "", "", "", $result1);
             }
             else
@@ -56 +57 @@
 
             mysql_free_result($result0);
+            mysql_free_result($result1);
         }
         mysql_close($db_id);