' $concat_cont grp_name $concat_cont '' $concat_end link, grp_name FROM $kldv.ppl2grp2subj JOIN $kldv.grp2subj ON grp2subj.grp2subj_id = ppl2grp2subj.grp2subj_id JOIN $kldv.grp ON grp.grp_id = grp2subj.grp_id WHERE ppl_id = {$_SESSION['ppl_id']} AND ppl2grp2subj.ppl_enter <= {$_SERVER['REQUEST_TIME']} AND ppl2grp2subj.ppl_exit > {$_SERVER['REQUEST_TIME']} ORDER BY grp_name EOQ ); /*$leerlingen = mdb2_query($db, <<' $concat_cont lln.ppl_login $concat_cont '' $concat_end nr, lln.ppl_forename voornaam, lln.ppl_prefix tussenv, lln.ppl_surname achternaam, $concat_begin ' (' $concat_cont grp.grp_name $concat_cont ')' $concat_end klas FROM $kldv.ppl JOIN $kldv.ppl2grp2subj ON ppl2grp2subj.ppl_id = ppl.ppl_id AND ppl2grp2subj.ppl_enter <= {$_SERVER['REQUEST_TIME']} AND ppl2grp2subj.ppl_exit > {$_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 grp.grp_name LIKE '%q' ORDER BY lln.ppl_surname, lln.ppl_forename, lln.ppl_prefix EOQ , $_GET['klas']);*/ $leerlingen_beter = mdb2_query($db, <<' $concat_cont ppl_login $concat_cont '' $concat_end AS nr, $concat_begin ppl_forename $concat_cont ' ' $concat_cont $ifnull(ppl_prefix, '') $concat_cont ' ' $concat_cont ppl_surname $concat_end AS leerling, sub.info AS groep FROM ( SELECT ppl_id, $group_concat_d(sub.info $group_concat_d_sep ';') AS info FROM ( SELECT grp.grp_id, $concat_begin grp_name $concat_cont '/' $concat_cont $group_concat(subj_abbrev) $concat_end info FROM $kldv.ppl2grp2subj JOIN $kldv.grp2subj ON grp2subj.grp2subj_id = ppl2grp2subj.grp2subj_id JOIN $kldv.subj ON subj.subj_id = grp2subj.subj_id JOIN $kldv.grp ON grp.grp_id = grp2subj.grp_id WHERE ppl_id = {$_SESSION['ppl_id']} AND ppl_enter <= {$_SERVER['REQUEST_TIME']} AND ppl_exit > {$_SERVER['REQUEST_TIME']} AND grp_name LIKE '%q' GROUP BY grp.grp_id, grp_name ) AS sub JOIN $kldv.ppl2grp ON ppl2grp.grp_id = sub.grp_id AND ppl2grp.ppl_enter <= {$_SERVER['REQUEST_TIME']} AND ppl2grp.ppl_exit > {$_SERVER['REQUEST_TIME']} GROUP BY ppl_id ) AS sub JOIN $kldv.ppl ON ppl.ppl_id = sub.ppl_id ORDER BY ppl_surname, ppl_forename, ppl_prefix EOQ , $_GET['klas']); html_start(); ?>

Klassen/lesgroepen: .

Leerlingen: 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 = {$_SESSION['ppl_id']} EOQ ); html_start(); echo("

Toetsen gemaakt door $naam

"); mdb2_res_table($toetsen); html_end(); break; } ?>