"; return; } if (empty($_GET["fKey"])) $_GET["fKey"]=""; if (empty($_GET["fMode"])) $_GET["fMode"]="view"; 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); $query1 = "SELECT Max(fCounter) FROM History"; $result1=mysql_query($query1, $db_id); $row1 = mysql_fetch_row($result1); $maxcounter=$row1[0]; mysql_free_result($result1); $query0="SELECT Concat(fKey1, fKey2) as ourkeys from ProgramOption "; $query0.="WHERE fCounter=".$maxcounter." "; if ($_GET["fProgram"]!="all") $query0.="AND fProgram='".$_GET["fProgram"]."' "; $query0.="GROUP BY ourkeys"; $result0=mysql_query($query0, $db_id); if (strcmp($_GET["fMode"], "edit")==0) printf("select key:
\n"); // else // printf("select key: \n"); if (strcmp($_GET["fMode"], "view")==0)//reload tables in case of mode 'view' printf("\n", $_GET["fProgram"], $_GET["fMode"]); else printf("\n", $_GET["fProgram"], $_GET["fMode"]); if (!empty($_GET["fKey"]) && strcmp("all", $_GET["fKey"])==0) printf(" --- all keys --- \n"); else printf(" --- all keys --- \n"); while ($row0 = mysql_fetch_row($result0)) if (!empty($_GET["fKey"]) && strcmp($row0[0], $_GET["fKey"])==0) printf("%s \n", $row0[0], $row0[0]); else printf("%s \n", $row0[0], $row0[0]); printf("\n"); if (strcmp($_GET["fMode"], "edit")==0) printf("
\nAdd Key\n", $_GET["fProgram"]); mysql_free_result($result0); mysql_close($db_id); ini_set("display_errors", "Off"); ini_set("mysql.trace_mode", "Off"); } ?>