query("SELECT 1 FROM pros_admin_rechte, pros_admin_rechte_zuord , pros_admin where pros_admin_rechte.pros_admin_rolle = pros_admin_rechte_zuord.pros_admin_rolle AND pros_admin_rechte_zuord.faid = pros_admin.faid AND pros_admin.user = '$user_admin' AND pros_admin_rechte_zuord.pros_admin_rolle = 'a_uebpros'"); $row = $result->fetch_array(); if ($row[0] != 1){ include("kurs/rechte.php"); exit;} // Rechteüberprüfung ende echo " Proseminarliste
"; $db = dbconnect(); $result = $db->query("SELECT id, FPRNr, Bezeichnung, Ansprechpart FROM pros_proseminar WHERE jahr=\"$jahrgang\" ORDER BY FPRNr asc"); while ($row = $result->fetch_array()){ echo " "; } echo"

Übersicht über die Proseminare
des Studienjahrgangs $jahrgang

Nr.

Beschreibung

Dozenten

$row[FPRNr].

$row[Bezeichnung]

 "; $result2 = $db->query("SELECT doz_titel, doz_vorname, doz_name FROM doz, pros_doz WHERE doz.doz_nr = pros_doz.doz_nr AND pros_doz.id = '$row[id]' ORDER BY doz_name ASC"); while ($row2 = $result2->fetch_array()){ echo"

$row2[doz_titel] $row2[doz_vorname] $row2[doz_name]
"; } echo"

"; ?>