equal
deleted
inserted
replaced
31 { |
31 { |
32 foreach ($result as $row) |
32 foreach ($result as $row) |
33 echo "<tr><td>Prüfart: </td><td>" . $row->al_pruefart_ID.": " . $row->al_pruefart_bez . "</td></tr>\n"; |
33 echo "<tr><td>Prüfart: </td><td>" . $row->al_pruefart_ID.": " . $row->al_pruefart_bez . "</td></tr>\n"; |
34 } |
34 } |
35 // Pruefintervall |
35 // Pruefintervall |
36 $sql = "SELECT al_pruefintv_ID,al_pruefintv_bez FROM fhiiqm.A_PruefIntv WHERE al_pruefintv_ID = '" . $al["pintv"] . "'"; |
36 if (!is_null($al["pintv"])) |
37 if ($result = $dbc->queryObjectArray($sql)) |
|
38 { |
37 { |
39 foreach ($result as $row) |
38 $sql = "SELECT al_pruefintv_ID,al_pruefintv_bez FROM fhiiqm.A_PruefIntv WHERE al_pruefintv_ID = '" . $al["pintv"] . "'"; |
40 echo "<tr><td>Prüfintervall: </td><td>" . $row->al_pruefintv_bez . "</td></tr>\n"; |
39 if ($result = $dbc->queryObjectArray($sql)) |
41 } |
40 { |
|
41 foreach ($result as $row) |
|
42 echo "<tr><td>Prüfintervall: </td><td>" . $row->al_pruefintv_bez . "</td></tr>\n"; |
|
43 } |
|
44 } |
42 // Raum |
45 // Raum |
43 $sql = "SELECT raum_nr,raum_name,r.geb_ID,geb_name |
46 $sql = "SELECT raum_nr,raum_name,r.geb_ID,geb_name |
44 FROM fhiiqm.Raum r INNER JOIN fhiiqm.Haus h ON r.geb_ID = h.geb_ID |
47 FROM fhiiqm.Raum r INNER JOIN fhiiqm.Haus h ON r.geb_ID = h.geb_ID |
45 WHERE raum_ID = '" . $al["raum"] . "'"; |
48 WHERE raum_ID = '" . $al["raum"] . "'"; |
46 if ($result = $dbc->queryObjectArray($sql)) |
49 if ($result = $dbc->queryObjectArray($sql)) |