source: trunk/www/db_po/get_timestamp.php@ 14007

<?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");
}
?>