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_uebersp'"); $row = $result->fetch_array(); if ($row[0] != 1){ include("kurs/rechte.php"); exit;} // Rechteüberprüfung ende echo " Übersicht über die Proseminare des Studienjahrgangs $stud_jahr[Jahrgang]

Übersicht über die Proseminare des Studienjahrgangs $jahrgang
"; $db = dbconnect(); // $query = "SELECT id, FPRNr, Bezeichnung, TN_max, bemerkung FROM pros_proseminar where order by FPRNr asc"; $query = "SELECT id, FPRNr, Bezeichnung, TN_max, bemerkung FROM pros_proseminar where Jahr=\"$jahrgang\" order by FPRNr asc"; $result = $db->query($query) or die ("Cannot execute query"); while ($row = $result->fetch_array()){ echo " "; } echo "

Nr.

 Bezeichnung

Prio 0 (admin)

Prio 1

Prio 2

Prio 3

Prio 4

$row[FPRNr]

 $row[Bezeichnung]
$row[bemerkung]

"; $query0 = "SELECT vorname, nachname FROM stud, pros_wunsch WHERE stud.uid = pros_wunsch.uid AND pros_wunsch.id = $row[id] AND pros_wunsch.prioritaet =0 ORDER BY nachname ASC"; $result0 = $db->query($query0) or die ("Cannot execute query"); while ($row0 = $result0->fetch_array()){ echo "$row0[vorname] $row0[nachname]
"; } echo"

"; $query0 = "SELECT vorname, nachname FROM stud, pros_wunsch WHERE stud.uid = pros_wunsch.uid AND pros_wunsch.id = $row[id] AND pros_wunsch.prioritaet =1 ORDER BY nachname ASC"; $result0 = $db->query($query0) or die ("Cannot execute query"); while ($row0 = $result0->fetch_array()){ echo "$row0[vorname] $row0[nachname]
"; } echo"

"; $query0 = "SELECT vorname, nachname FROM stud, pros_wunsch WHERE stud.uid = pros_wunsch.uid AND pros_wunsch.id = $row[id] AND pros_wunsch.prioritaet =2 ORDER BY nachname ASC"; $result0 = $db->query($query0) or die ("Cannot execute query"); while ($row0 = $result0->fetch_array()){ echo "$row0[vorname] $row0[nachname]
"; } echo"

"; $query0 = "SELECT vorname, nachname FROM stud, pros_wunsch WHERE stud.uid = pros_wunsch.uid AND pros_wunsch.id = $row[id] AND pros_wunsch.prioritaet =3 ORDER BY nachname ASC"; $result0 = $db->query($query0) or die ("Cannot execute query"); while ($row0 = $result0->fetch_array()){ echo "$row0[vorname] $row0[nachname]
"; } echo"

"; $query0 = "SELECT vorname, nachname FROM stud, pros_wunsch WHERE stud.uid = pros_wunsch.uid AND pros_wunsch.id = $row[id] AND pros_wunsch.prioritaet =4 ORDER BY nachname ASC"; $result0 = $db->query($query0) or die ("Cannot execute query"); while ($row0 = $result0->fetch_array()){ echo "$row0[vorname] $row0[nachname]
"; } echo"

"; ?>