--- 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ü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ü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ü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