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

\n"); printf("\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); $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); printf("\n"); printf("\n"); printf("\n"); printf("\n"); printf("\n"); printf("\n"); //date fields printf("\n"); $rowcount=0; for ($i=2; $i<4; $i++) { if ($i==2) printf("\n"); //reset mysql result to loop again over it if ($i==2 && $rowcount > 0) mysql_data_seek($result0, 0); if ($i==2) printf("\n"); } printf("\n"); mysql_free_result($result0); //print pulldown for programs/key and buttons printf("\n"); //checkboxes to show/hide part of the table printf("\n"); for ($i=2; $i<4; $i++) { if ($i==2) printf("\n"); } printf("\n"); //list of POs printf("\n"); printf("\n"); printf("\n"); printf("\n"); printf("\n
Configuration 1\n"); printf("\n"); printf("Configuration 2
Date:  \n"); else printf("Date:  \n"); //buttons to show next/prev timestamp printf("\n", $i, $i); printf("\n", $i, $i); //reset date button printf("\n", $i, $i); //input field printf("
\n", $i); printf("\n"); //pull down menus printf("
\n", $i); //select for years printf("
\n", $i); printf("
\n"); //select for months printf("
\n", $i); printf("\n"); printf("
\n"); //select for days printf("
\n", $i); printf("\n"); printf("
\n"); //select for hours printf("
\n", $i); printf("\n"); printf("
\n"); //select for minutes printf("
\n", $i); printf("\n"); printf("
\n"); //select for seconds printf("
\n", $i); printf("\n"); printf("
\n"); printf("
\n"); printf("
\n"); //radio button to select input-format for date printf("pulldown \n", $i, $i); printf("text input \n", $i, $i); printf("
\n"); printf("
Select a subset of program options:\n"); printf("
\n"); printf("
\n"); //printf("\n"); printf("
\n"); else printf("\n"); printf("Show:\n"); printf("indices\n", $i, $i); printf("validsince\n", $i, $i); printf("description\n", $i, $i); printf("min\n", $i, $i); printf("max\n", $i, $i); printf("user\n", $i, $i); printf("
\n"); echo (file_get_contents("index-footer.html")); ini_set("display_errors", "Off"); ini_set("mysql.trace_mode", "Off"); } ?>