{$_SERVER['REQUEST_TIME']} JOIN $kldv.grp2subj ON grp2subj.grp2subj_id = ppl2grp2subj.grp2subj_id JOIN $kldv.grp ON grp.grp_id = grp2subj.grp_id JOIN $kldv.subj ON subj.subj_id = grp2subj.subj_id JOIN $kldv.ppl2grp ON ppl2grp.grp_id = grp.grp_id AND ppl2grp.ppl_enter <= {$_SERVER['REQUEST_TIME']} AND ppl2grp.ppl_exit >{$_SERVER['REQUEST_TIME']} JOIN $kldv.ppl AS lln ON lln.ppl_id = ppl2grp.ppl_id WHERE ppl.ppl_id = {$_SESSION['ppl_id']} AND lln.ppl_id = %i ORDER BY lln.ppl_surname, lln.ppl_forename, lln.ppl_prefix EOQ , $_GET['ppl_id']); if (!$ppl_id && !$_SESSION['admin']) error_user("Geen toegang", "Je geeft geen les aan deze leerling, de gegevens zijn niet toegankelijk"); $naam = mdb2_single_val($db, "SELECT $concat_begin ppl_forename $concat_cont ' ' $concat_cont ppl_prefix $concat_cont ' ' $concat_cont ppl_surname $concat_cont ' (' $concat_cont ppl_login $concat_cont ')' $concat_end FROM $kldv.ppl WHERE ppl_id = %i", $_GET['ppl_id']); $toetsen = mdb2_query($db, <<details' $concat_end details FROM results JOIN tests ON tests.test_id = results.test_id JOIN testtypes ON testtypes.testtype_id = tests.testtype_id JOIN test_levels ON test_levels.test_level_id = tests.level_id JOIN testtype2scoretype ON testtype2scoretype.testtype_id = testtypes.testtype_id AND ordering = 1 JOIN scoretypes ON scoretypes.scoretype_id = testtype2scoretype.scoretype_id JOIN scores ON scores.scoretype_id = scoretypes.scoretype_id AND scores.result_id = results.result_id LEFT JOIN scores_INTEGER ON scores_INTEGER.score_id = scores.score_id LEFT JOIN scores_VARCHAR32 ON scores_VARCHAR32.score_id = scores.score_id WHERE ppl_id = %i ORDER BY tests.test_id EOQ , $_GET['ppl_id']); // maak overzicht gemaakte toetsen html_start(); echo("

Toetsen gemaakt door $naam

"); mdb2_res_table($toetsen); //echo("
ppl_id=$ppl_id"); html_end(); ?>