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