fhiiqm/form/info_allg_search_form.inc.php
changeset 31 0a1eb975fbd9
parent 29 72f79dab938e
equal deleted inserted replaced
30:d02d02efc55a 31:0a1eb975fbd9
    42             echo "</select></td></tr>\n";
    42             echo "</select></td></tr>\n";
    43             echo "<tr><td>Infotyp</td>";
    43             echo "<tr><td>Infotyp</td>";
    44             echo "<td><select name='inf[ityp]'>";
    44             echo "<td><select name='inf[ityp]'>";
    45                 if ($inf["ityp"] == -1) $select = " selected "; else $select = "";
    45                 if ($inf["ityp"] == -1) $select = " selected "; else $select = "";
    46                 echo "<option $select value=\"-1\"></option>\n";
    46                 echo "<option $select value=\"-1\"></option>\n";
    47                 $sql = "SELECT infotyp_ID, infotyp_bez FROM Info_Typ ORDER BY 1";
    47                 $sql = "SELECT infotyp_ID, infotyp_bez FROM Info_Typ ORDER BY CONVERT(infotyp_ID,CHAR)";
    48                 if ($result = $dbc->queryObjectArray($sql))
    48                 if ($result = $dbc->queryObjectArray($sql))
    49                 {
    49                 {
    50                     $select = "";
    50                     $select = "";
    51                     foreach ($result as $row)
    51                     foreach ($result as $row)
    52                     {
    52                     {