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

Timestamp:

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

Author:

Daniela Dorner

Message:

*** empty log message ***

File:

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

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

@@ -50 +50 @@
         mysql_select_db($db);
 
-        $query0  = "SELECT fRunBookDate AS Date, fRunBookText AS Entry ";
+        $query0  = "SELECT SQL_CALC_FOUND_ROWS fRunBookDate AS Date, fRunBookText AS Entry ";
         $query0 .= "FROM " . $db . ".RunBook ";
         $query0 .= "WHERE fRunBookDate REGEXP '^" . $_GET["fDate"] . "' ";
@@ -63 +63 @@
 
         $result0 = mysql_query($query0, $db_id);
+        $result1 = mysql_query("SELECT FOUND_ROWS()", $db_id);
 
         if ($result0)
@@ -76 +77 @@
                 (
                 );
-                PrintMagicTable($result0, $alias, $rightalign, "", "", "", "", $_GET);
+                PrintMagicTable($result0, $alias, $rightalign, "", "", "", $result1);
             }
             else
@@ -82 +83 @@
 
             mysql_free_result($result0);
+            mysql_free_result($result1);
         }
         mysql_close($db_id);