--- a/fhiiqm/inc/raum_dat_show.inc.php	Thu Jan 12 11:41:22 2012 +0100
+++ b/fhiiqm/inc/raum_dat_show.inc.php	Mon Feb 06 13:44:00 2012 +0100
@@ -26,6 +26,14 @@
                 foreach ($result as $row)
                 echo "<tr><td>Raumtyp: </td><td>" . $row->raumtyp_bez . "</td></tr>\n";
             }
+            // Reinigungtyp
+            $sql = "SELECT reinigung_typ_ID, reinigung_typ_bez FROM fhiiqm.Reinigung_Typ
+                        WHERE reinigung_typ_ID = '" . $raum['reityp'] . "'";
+            if ($result = $dbc->queryObjectArray($sql))
+            {
+                foreach ($result as $row)
+                echo "<tr><td>Reinigungstyp: </td><td>" . $row->reinigung_typ_ID." - ".$row->reinigung_typ_bez . "</td></tr>\n";
+            }
             if ($raum["rflae"] == "NULL") $raum["rflae"] = "&nbsp;";
             echo "<tr><td>Raum-Fl&auml;che (m<sup>2</sup>): </td><td>" . str_replace(".",",",$raum['rflae']) . "<td></td></tr>\n";
             if (file_exists("raeume/$rfile"))