query("SELECT firstname, lastname, mnumber, blackboard FROM students ORDER BY lastname"); print ""; print ""; while ($student = $result->fetch(PDO::FETCH_ASSOC)) { $result2 = $db->query("SELECT manydone, thisdone FROM workdone WHERE mnumber=" . $student['mnumber'] . " AND session=" . $SESSIONS_actual)->fetch(PDO::FETCH_NUM); $exdone = $result2[0]; if ($exdone == "") { $exdone=0; } $thisdone = $result2[1]; print ""; print ""; print ""; print ""; print ""; print ""; print ""; } print "

First name	Last name	Matr.nummer	Examples	Blackboard
" . $student['firstname'] . "	" . $student['lastname'] . "	" . $student['mnumber'] . "	" . $thisdone . " (" . $exdone . "/" . $SESSIONS[$SESSIONS_actual]['nexamples'] . ")	" . $student['blackboard'] . "

"; ?>