source: trunk/www/db_po/get_progs.php@ 18066

<?php
{
    ini_set("display_errors", "On");
    ini_set("mysql.trace_mode", "On");

    if (empty($_GET["fProgram"]))
        $_GET["fProgram"]="";
    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");

    if (strcmp($_GET["fMode"], "view")==0)
        printf("<select style='width: 150px' id='prog' size='1' onchange='get_keys(this.value,\"\",\"%s\");get_values(2,\"all\",\"all\");get_values(3,\"all\",\"all\");CompareValues();' class='Width'>\n", $_GET["fMode"]);
    else
        printf("<select style='width: 150px' id='prog' size='10' onchange=\"get_keys(this.value,'','%s');get_values(1,this.value,'all');\" class='Width'>\n", $_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");
    if (strcmp($_GET["fMode"], "edit")==0)
        printf("<br>\n<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");
}
?>