fhiiqm/inc/anlage_dat_show.inc.php
changeset 23 a382de56a8e4
parent 22 aae5b0ecc47b
--- a/fhiiqm/inc/anlage_dat_show.inc.php	Thu Jan 12 11:41:22 2012 +0100
+++ b/fhiiqm/inc/anlage_dat_show.inc.php	Mon Feb 06 13:44:00 2012 +0100
@@ -33,12 +33,15 @@
                     echo "<tr><td>Pr&uuml;fart: </td><td>" . $row->al_pruefart_ID.": " . $row->al_pruefart_bez . "</td></tr>\n";
             }
             // Pruefintervall
-            $sql = "SELECT al_pruefintv_ID,al_pruefintv_bez FROM fhiiqm.A_PruefIntv WHERE al_pruefintv_ID = '" . $al["pintv"] . "'";
-            if ($result = $dbc->queryObjectArray($sql))
+            if (!is_null($al["pintv"]))
             {
-                foreach ($result as $row)
-                    echo "<tr><td>Pr&uuml;fintervall: </td><td>" . $row->al_pruefintv_bez . "</td></tr>\n";
-            }
+                $sql = "SELECT al_pruefintv_ID,al_pruefintv_bez FROM fhiiqm.A_PruefIntv WHERE al_pruefintv_ID = '" . $al["pintv"] . "'";
+                if ($result = $dbc->queryObjectArray($sql))
+                {
+                    foreach ($result as $row)
+                        echo "<tr><td>Pr&uuml;fintervall: </td><td>" . $row->al_pruefintv_bez . "</td></tr>\n";
+                }
+            }    
             // Raum
             $sql = "SELECT raum_nr,raum_name,r.geb_ID,geb_name 
                     FROM fhiiqm.Raum r INNER JOIN fhiiqm.Haus h ON r.geb_ID = h.geb_ID