query("SELECT COUNT(*) FROM students")->fetch(PDO::FETCH_NUM)[0] == 0) { block("red", "no students registered"); exit; } block("black", "summary of everything for " . date("d.m.Y H:i")); $result = $db->query("SELECT firstname, lastname, mnumber, blackboard FROM students ORDER BY lastname"); print ""; print ""; while ($student = $result->fetch(PDO::FETCH_ASSOC)) { $exdone = $db->query("SELECT manydone FROM workdone WHERE mnumber=" . $student['mnumber'])->fetch(PDO::FETCH_NUM); $totexdone = 0; foreach($exdone as $subdone) { $totexdone += $subdone; } print ""; print ""; print ""; print ""; print ""; print ""; print ""; } print "

First name	Last name	Matr.nummer	Examples	Blackboard
" . $student['firstname'] . "	" . $student['lastname'] . "	" . $student['mnumber'] . "	" . $totexdone . "/" . $SESSIONS_totex_nextinc . "	" . $student['blackboard'] . "

"; ?>