--- a/fhiiqm/keytyp_ma_search.php Wed Aug 06 09:42:40 2014 +0200
+++ b/fhiiqm/keytyp_ma_search.php Fri Feb 05 14:03:40 2016 +0100
@@ -143,7 +143,7 @@
else
{
$sql = "SELECT km.keytyp_ID, key_level, pers_anz AS anzahl,pers_date, pers_bem, depot_ID,
- CONCAT (nachname, ', ',vorname, ', ' , IFNULL(abt_name,''),' (',CASE aktiv WHEN 0 THEN 'inaktiv' ELSE 'aktiv' END, ')') AS nvname,
+ CONCAT (nachname, IFNULL(CONCAT(', ',vorname),''), ', ' , IFNULL(abt_name,''),' (',CASE aktiv WHEN 0 THEN 'inaktiv' ELSE 'aktiv' END, ')') AS nvname,
(CASE WHEN pers_action = 'get' THEN 'erhalten' WHEN pers_action = 'out' THEN 'zurück' ELSE 'verloren' END) AS status
FROM fhiiqm.Mitarbeiter m
INNER JOIN Keytyp_MA km ON m.persknr=km.persknr