Mercurial Mercurial > IQM / diff
summary | shortlog | changelog | graph | tags | bookmarks | branches | files | changeset | file | latest | revisions | annotate | diff | comparison | raw | help
Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
fhiiqm/prod_hier.php
changeset 25 482252ff12fd
parent 24 15f33315f045
child 28 8d8bce56918f 
--- a/fhiiqm/prod_hier.php	Fri Mar 02 13:54:32 2012 +0100
+++ b/fhiiqm/prod_hier.php	Thu Apr 05 15:35:43 2012 +0200
@@ -83,15 +83,15 @@
                                 WHERE prod_group_ID IN ($listg)
                                 ORDER BY 2";
                     else
-                        $sql = "SELECT prod_ber_ID, prod_ber_name FROM Produkt_Bereich ORDER BY 2";
+                        $sql = "SELECT prod_ber_ID, prod_ber_name FROM Produkt_Bereich ORDER BY 1";
                     if ($result = $dbc->queryObjectArray($sql))
                     {
                         foreach ($result as $row)
                         {
                             if ($row->prod_ber_ID == $prods['ber'])
-        					   echo "<option selected value=\"$row->prod_ber_ID\">$row->prod_ber_name ($row->prod_ber_ID)</option>\n";
+        					   echo "<option selected value=\"$row->prod_ber_ID\">$row->prod_ber_ID $row->prod_ber_name</option>\n";
         				    else
-        					   echo "<option value=\"$row->prod_ber_ID\">$row->prod_ber_name ($row->prod_ber_ID)</option>\n";
+        					   echo "<option value=\"$row->prod_ber_ID\">$row->prod_ber_ID $row->prod_ber_name</option>\n";
                         }
                 }
                 ?>
@@ -120,9 +120,9 @@
                         foreach ($result as $row)
                         {
                             if ($row->prod_group_ID == $prods['grp'])
-        					   echo "<option selected value=\"$row->prod_group_ID\">$row->prod_group_name ($row->prod_group_hier)</option>\n";
+        					   echo "<option selected value=\"$row->prod_group_ID\">$row->prod_group_hier $row->prod_group_name</option>\n";
         				    else
-        					   echo "<option value=\"$row->prod_group_ID\">$row->prod_group_name ($row->prod_group_hier)</option>\n";
+        					   echo "<option value=\"$row->prod_group_ID\">$row->prod_group_hier $row->prod_group_name</option>\n";
                         }
                 }
                 ?>
IQM