{$_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
JOIN results ON results.ppl_id = lln.ppl_id
WHERE ppl.ppl_id = {$_SESSION['ppl_id']}
AND result_id = $result_id
ORDER BY lln.ppl_surname, lln.ppl_forename, lln.ppl_prefix
EOQ
);
if (!$ppl_id) error_user("Geen toegang", "Je geeft geen les aan deze leerling, de gegevens zijn niet toegankelijk");
html_start(); ?>
Commentaar