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