query($sql1); $anz1 = $result1->num_rows; $sql2 = "SELECT * FROM User WHERE userId != '1' AND userIsBuero = 'Y' ORDER BY userLastname ASC, userFirstname ASC;"; $result2 = $db->query($sql2); $anz2 = $result2->num_rows; $sql3 = "SELECT * FROM User WHERE userId != '1' AND userIsAdmin = 'N' AND userIsBuero = 'N' AND userDeact = 'N' ORDER BY userLastname ASC, userFirstname ASC;"; $result3 = $db->query($sql3); $anz3 = $result3->num_rows; $sql4 = "SELECT * FROM User WHERE userId != '1' AND userIsAdmin = 'N' AND userIsBuero = 'N' AND userDeact = 'Y' ORDER BY userLastname ASC, userFirstname ASC;"; $result4 = $db->query($sql4); $anz4 = $result4->num_rows; $anz = $anz1 + $anz2 + $anz3 + $anz4; ?> fetch_assoc() ) { ?> fetch_assoc() ) { ?> fetch_assoc() ) { ?> fetch_assoc() ) { ?>

	Nachname, Vorname	Email
	Administratoren
	Bürokräfte
	Aktive Benutzer
	Deaktivierte Benutzer
	neuen Benutzer anlegen