fhiiqm/form/vertragmf_form.inc.php
changeset 39 4ce411ed28b6
parent 36 4411d3239444
child 40 6f4b105daa24
--- a/fhiiqm/form/vertragmf_form.inc.php	Mon Jul 01 14:36:18 2013 +0200
+++ b/fhiiqm/form/vertragmf_form.inc.php	Wed Jul 31 15:10:48 2013 +0200
@@ -154,7 +154,7 @@
                     $select = null;
                     if (is_array($vtr['cpers'])) $select = in_array( "-1", $vtr['cpers'] ) ? ' selected' : null;
                     echo "<option $select value=\"-1\"></option>\n";
-                    $sql = "SELECT persknr, CONCAT (nachname, ', ',vorname,' (',CASE aktiv WHEN 1 THEN 'aktiv' ELSE 'inaktiv' END, ')') as pname FROM fhiiqm.Mitarbeiter WHERE aktiv < 2 ORDER BY 2";
+                    $sql = "SELECT persknr, CONCAT (nachname, ', ',IFNULL(vorname,''),' (',CASE aktiv WHEN 1 THEN 'aktiv' ELSE 'inaktiv' END, ')') as pname FROM fhiiqm.Mitarbeiter WHERE aktiv < 2 ORDER BY 2";
                     if ($result = $dbc->queryObjectArray($sql))
                     {
                         foreach ($result as $row)