source: trunk/www/db_po/get_keys.php@ 11439

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

    if (empty($_GET["fProgram"]))
    {
        echo "Please select a program.<br>";
        return;
    }

    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);

    $query0="SELECT fKey from ProgramOption ";
    if ($_GET["fProgram"]!="all")
        $query0.="WHERE fProgram='".$_GET["fProgram"]."' ";
    $query0.="GROUP BY fKey";

    $result0=mysql_query($query0, $db_id);

    printf("<td>Please select a key:</td>\n");
    printf("<td><select name='key' size='1' onchange=\"get_values('%s',this.value)\"class='Width'>\n", $_GET["fProgram"]);
    printf("<option value='empty'> ---select key--- </option>\n");
    printf("<option value='newkey'> add new key </option>\n");
    while ($row0 = mysql_fetch_row($result0))
        printf("<option value='%s'>%s </option>\n", $row0[0], $row0[0]);
    printf("</select>\n</td>\n");
    mysql_free_result($result0);

    mysql_close($db_id);

    ini_set("display_errors", "Off");
    ini_set("mysql.trace_mode", "Off");
}
?>