{$herinfo['period_deadline']}
JOIN $kldv.grp2subj ON grp2subj.grp2subj_id = ppl2grp2subj.grp2subj_id
JOIN $kldv.subj ON subj.subj_id = grp2subj.subj_id
JOIN $kldv.ppl2grp ON ppl2grp.grp_id = grp2subj.grp_id
AND ppl2grp.ppl_enter <= {$herinfo['period_deadline']}
AND ppl2grp.ppl_exit > {$herinfo['period_deadline']}
JOIN $kldv.ppl ON ppl.ppl_id = ppl2grp.ppl_id
JOIN $kldv.ppl2grp AS ppl2grp2
ON ppl2grp2.ppl_id = ppl.ppl_id
AND ppl2grp2.ppl_enter <= {$herinfo['period_deadline']}
AND ppl2grp2.ppl_exit > {$herinfo['period_deadline']}
JOIN period2grp ON period2grp.grp_id = ppl2grp2.grp_id
LEFT JOIN rex ON rex.ppl_id = ppl.ppl_id AND rex.period_id = {$herinfo['period_id']}
WHERE altlogin = '%q' AND subj_abbrev = 'mt' AND period2grp.period_id = {$herinfo['period_id']}
ORDER BY ppl_surname, ppl_forename, ppl_prefix
EOQ
, $_SESSION['username']);
if ($_SESSION['admin']) $herinfo['expired'] = 0;
$iface = '';
while ($leerling = $mentorleerlingen->fetchrow(MDB2_FETCHMODE_ASSOC)) {
$iface .= '
';
// maak een lijst van vakken die de leerling heeft
$vakken = mdb2_query($db, << {$herinfo['period_deadline']}
AND subj_abbrev IS NOT NULL
AND subj_abbrev != ''
ORDER BY subj_abbrev
EOQ
);
//mdb2_res_table($vakken);
$iface .= '
';
$iface .= '
';
$iface .= '
';
}
if ($iface == '') error_user('Je hebt volgens dit systeem geen mentorleerlingen in klassen die deelnemen aan de herkansing', 'Neem contact op met de beheerder als dit niet klopt.');
html_start();
echo('');
//mdb2_res_table($mentorleerlingen);
html_end();
?>