Index: trunk/www/db_po/get_timestamp.php
===================================================================
--- trunk/www/db_po/get_timestamp.php	(revision 11503)
+++ trunk/www/db_po/get_timestamp.php	(revision 11503)
@@ -0,0 +1,55 @@
+<?php
+{
+    ini_set("display_errors", "On");
+    ini_set("mysql.trace_mode", "On");
+
+    if (empty($_GET["fStatusDate"]))
+        $_GET["fStatusDate"]="";
+    if (empty($_GET["fDirection"]))
+    {
+        echo "Please give the direction.<br>";
+        return;
+    }
+
+    include("db.php");
+    $db_id = mysql_pconnect($host, $user, $pw);
+    if ($db_id==FALSE)
+    {
+        printf("mysql_connect returned the following error: %s\n", mysql_error());
+        die("");
+    }
+    mysql_select_db($db);
+
+    if (strcmp($_GET["fDirection"], "next")==0)
+        $query0 ="SELECT Max(fCounter)+1 FROM History WHERE fValidFrom like '".$_GET["fStatusDate"]."%'";
+    if (strcmp($_GET["fDirection"], "prev")==0)
+        $query0 ="SELECT Max(fCounter)-1 FROM History WHERE fValidFrom like '".$_GET["fStatusDate"]."%'";
+    $result0=mysql_query($query0, $db_id);
+    $row0 = mysql_fetch_row($result0);
+    $counter1=$row0[0];
+    mysql_free_result($result0);
+
+    $query1 = "SELECT Max(fCounter) FROM History";
+    $result1=mysql_query($query1, $db_id);
+    $row1 = mysql_fetch_row($result1);
+    $counter2=$row1[0];
+    mysql_free_result($result1);
+
+    if ($counter1>$counter2)
+        $counter=$counter2;
+    else
+        $counter=$counter1;
+
+    $query1 = "SELECT fValidFrom FROM History WHERE fCounter=".$counter;
+    $result1=mysql_query($query1, $db_id);
+    $row1 = mysql_fetch_row($result1);
+    $validfrom=$row1[0];
+    mysql_free_result($result1);
+    echo $validfrom;
+
+    mysql_close($db_id);
+
+    ini_set("display_errors", "Off");
+    ini_set("mysql.trace_mode", "Off");
+}
+?>
