query("SELECT 1 FROM stan_admin_rechte, stan_admin_rechte_zuord , stan_admin where stan_admin_rechte.stan_admin_rolle = stan_admin_rechte_zuord.stan_admin_rolle AND stan_admin_rechte_zuord.said = stan_admin.said AND stan_admin.user = '$user_admin' AND stan_admin_rechte_zuord.stan_admin_rolle = 'a_offerst'"); $row = $result->fetch_array(); if ($row[0] != 1){ include("kurs/rechte.php"); exit;} // Rechteüberprüfung ende echo" Unbearbeitete Anträge

Unbearbeitete Anträge
"; $db = dbconnect(); $query = "SELECT distinct Nachname, Vorname, AG, Jahrgang,stud.uid, stan_antrag.saaid FROM stud, stan_antrag WHERE stan_antrag.uid = stud.uid AND (stan_antrag.status = '0' or stan_antrag.status = '1') AND stan_antrag.zuweisung IS NULL AND stud.durchgefallen!=\"Y\" AND stud.jahrgang = '$jahrgang' AND stud.hs = '$hs' AND (stud.stg = 'I') ORDER BY beginn, Nachname"; $result = $db->query($query) or die ("Cannot execute query"); while ($row = $result->fetch_array()){ $block = get_block($row['saaid'], $row['Jahrgang']); echo " "; } echo "

Name

 Block AG

$row[Nachname], $row[Vorname]

$block $row[AG]/$row[Jahrgang]
"; ?>