\n"); printf("window.onload = function () { get_progs(\"all\",1,'view'); get_keys(\"all\",\"all\",1,'view'); }\n"); printf("\n"); include("db.php"); printf("This page is to view the DB %s.\n", $db); printf("For edit, please go here.

\n"); $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); printf("\n"); printf("\n"); printf("\n"); printf("\n"); printf("\n"); printf("\n"); printf("\n"); for ($i=2; $i<4; $i++) { printf("\n"); } printf("\n"); $query0="SELECT DATE_FORMAT(fValidFrom, '%Y') AS valid FROM History WHERE NOT fValidFrom='0000-00-00 00:00:00' group by valid"; $result0=mysql_query($query0, $db_id); //date fields printf("\n"); $rowcount=0; for ($i=2; $i<4; $i++) { printf("\n"); if ($i==2 && $rowcount > 0) mysql_data_seek($result0, 0); } printf("\n"); mysql_free_result($result0); //list of POs printf("\n"); printf("\n"); printf("\n"); printf("\n"); printf("\n
\n"); //printf("\n"); printf("\n"); printf("\n"); printf("
\n"); printf("pulldown \n", $i, $i); printf("text input \n", $i, $i); printf("
\n"); //input field printf("\n"); //pull down menus printf("
Date:\n", $i); //select for years printf("
\n", $i); printf("
\n"); //select for months printf("
\n", $i); printf("
\n"); //select for days printf("
\n", $i); printf("
\n"); //select for hours printf("
\n", $i); printf("
\n"); //select for minutes printf("
\n", $i); printf("
\n"); //select for seconds printf("
\n"); //buttton to show next timestamp //printf("\n", $i, $i); printf("\n", $i, $i); printf("\n", $i, $i); printf("
\n"); echo (file_get_contents("index-footer.html")); ini_set("display_errors", "Off"); ini_set("mysql.trace_mode", "Off"); } ?>