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

Timestamp:

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

Author:

Daniela Dorner

Message:

*** empty log message ***

File:

• trunk/MagicSoft/Mars/datacenter/db/querystar.php (modified) (2 diffs)

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

@@ -3 +3 @@
     function CreateQuery($_GET, $alias, $checkwhere)
     {
-        $query0 = "SELECT fSequenceFirst as 'Sequence#' ";
+        $query0 = "SELECT SQL_CALC_FOUND_ROWS fSequenceFirst as 'Sequence#' ";
 
         foreach ($_GET as $key => $element)
@@ -160 +160 @@
 
         $result0 = mysql_query($query0, $db_id);
+        $result1 = mysql_query("SELECT FOUND_ROWS()", $db_id);
 
         if ($result0)
         {
             if ($html=="1")
-                PrintMagicTable($result0, $alias, $rightalign, "", "", "", "", $_GET);
+                PrintMagicTable($result0, $alias, $rightalign, "", "", "", "", $result1);
             else
                 PrintText($result0);
 
             mysql_free_result($result0);
+            mysql_free_result($result1);
         }
         mysql_close($db_id);