Changeset 8333 for trunk/MagicSoft/Mars/datacenter/db/include.php

Timestamp:

02/26/07 12:59:57 (18 years ago)

Author:

Daniela Dorner

Message:

*** empty log message ***

File:

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

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

@@ -223 +223 @@
 
     return $max;
+}
+
+function GetMaxDate($field, $table, $host, $user, $pw, $db)
+{
+    $db_id = mysql_connect($host, $user, $pw);
+    if ($db_id==FALSE)
+    {
+            printf("mysql_connect returned the following error:<br>");
+            printf("%s<br>", mysql_error());
+            die("");
+    }
+
+    $query  = "SELECT DATE_FORMAT(if(MAX(" . $field . ")<'13:00:00', MAX(" . $field . "), ADDDATE(MAX(" . $field . "), INTERVAL +1 DAY)), '%Y-%m-%d') FROM " . $db . "." . $table;
+    $result = mysql_query($query);
+    if (!$result)
+        return "0";
+
+    $row = mysql_fetch_row($result);
+
+    $maxdate = $row[0];
+
+    mysql_free_result($result);
+    mysql_close($db_id);
+
+    return $maxdate;
 }