Add another ORDER BY part

diff --git a/masks/arbeitsberichte.php b/masks/arbeitsberichte.php
index c301d2a..3d94103 100644 (file)
--- a/masks/arbeitsberichte.php
+++ b/masks/arbeitsberichte.php
@@ -355,9 +355,9 @@ $mask = array(
                                            'sql' => 'SELECT id,kostenstelle AS text FROM kostenstellen WHERE gebiet = {gebiet} ORDER BY text',
                                            ),
                              'anbaugeraete' => 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 ' .
                                                     'JOIN gerate ON anbaugeraete.geraetetyp = gerate.geraetetyp ' .

-                                                    'WHERE gerate.id = {geraet}',
+                                                    'WHERE gerate.id = {geraet} ORDER BY text',

                                            ),
                                   ),
              );
                                            ),
                                   ),
              );