Index: /trunk/www/db_po/get_progs.php
===================================================================
--- /trunk/www/db_po/get_progs.php	(revision 11501)
+++ /trunk/www/db_po/get_progs.php	(revision 11501)
@@ -0,0 +1,58 @@
+<?php
+{
+    ini_set("display_errors", "On");
+    ini_set("mysql.trace_mode", "On");
+
+    if (empty($_GET["fProgram"]))
+        $_GET["fProgram"]="";
+    if (empty($_GET["fSelectSize"]))
+        $_GET["fSelectSize"]="10";
+    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 fProgram FROM ProgramOption ";
+    $query0.="WHERE fCounter=".$maxcounter." ";
+    $query0.="GROUP BY fProgram";
+    $result0=mysql_query($query0, $db_id);
+
+    if (strcmp($_GET["fMode"], "edit")==0)
+        printf("select program: <br>\n");
+    else
+        printf("select program: \n");
+    printf("<select style='width: 120px' id='prog' size='%s' onchange=\"get_keys(this.value,'','%s','%s')\" class='Width'>\n",
+           $_GET["fSelectSize"], $_GET["fSelectSize"], $_GET["fMode"]);
+    if (!empty($_GET["fProgram"]) && strcmp("all", $_GET["fProgram"])==0)
+        printf("<option value='all' selected> --- all programs --- </option>\n");
+    else
+        printf("<option value='all'> --- all programs --- </option>\n");
+    while ($row0 = mysql_fetch_row($result0))
+        if (!empty($_GET["fProgram"]) && strcmp($row0[0],$_GET["fProgram"])==0)
+            printf("<option value='%s' selected>%s </option>\n", $row0[0], $row0[0]);
+        else
+            printf("<option value='%s'>%s </option>\n", $row0[0], $row0[0]);
+    printf("</select>\n<br>\n");
+    if (strcmp($_GET["fMode"], "edit")==0)
+        printf("<button onClick='addRow(1,\"\",\"\",\"\",\"\",\"\");' id='addrowprog' style='display:inline'>Add Prg/Key</button>\n");
+    mysql_free_result($result0);
+
+    mysql_close($db_id);
+
+    ini_set("display_errors", "Off");
+    ini_set("mysql.trace_mode", "Off");
+}
+?>