Add another ORDER BY part
[misc/kostenrechnung] / masks / arbeitsberichte.php
index c301d2a..3d94103 100644 (file)
@@ -355,9 +355,9 @@ $mask = array(
                                            'sql' => 'SELECT id,kostenstelle AS text FROM kostenstellen WHERE gebiet = {gebiet} ORDER BY text',
                                            ),
                              'anbaugeraete' => array(
-                                           'sql' => 'SELECT anbaugeraete.id,anbaugeraet as TEXT FROM anbaugeraete ' .
+                                           'sql' => 'SELECT anbaugeraete.id,anbaugeraet as text FROM anbaugeraete ' .
                                                     'JOIN gerate ON anbaugeraete.geraetetyp = gerate.geraetetyp ' .
-                                                    'WHERE gerate.id = {geraet}',
+                                                    'WHERE gerate.id = {geraet} ORDER BY text',
                                            ),
                                   ),
              );