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

Timestamp:

02/28/06 21:24:09 (19 years ago)

Author:

Daniela Dorner

Message:

*** empty log message ***

File:

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

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

@@ -19 +19 @@
         ini_set("mysql.trace_mode", "Off");
         ini_set("display_errors", "Off");
+
+        printf("Night&nbsp;(yyyy-mm-dd)&nbsp;<input name=\"fNight\" type=\"text\" size=\"10\" maxlength=\"10\" value=\"");
+        printf("%s\">&nbsp;&nbsp;&nbsp;\n", $_GET["fNight"]);
 
         printf("<input class='Width' type='submit' value='Query Table'>&nbsp;&nbsp;&nbsp;\n");
@@ -48 +51 @@
         if (!empty($_GET["fRegexp"]))
             $query0 .= "AND fRunBookText REGEXP '" . $_GET["fRegexp"] . "' ";
+
+        if (!empty($_GET["fNight"]))
+            $query0 .= "AND fRunBookDate < '" . $_GET["fNight"] . " 13:00:00' AND fRunBookDate > ADDDATE( '" . $_GET["fNight"] . " 13:00:00', INTERVAL -1 DAY) ";
 
         $query0 .= "ORDER BY fRunBookDate";