{$_SERVER['REQUEST_TIME']} JOIN $kldv.grp2subj USING (grp_id) JOIN $kldv.ppl2grp2subj ON ppl2grp2subj.grp2subj_id = grp2subj.grp2subj_id AND ppl2grp2subj.ppl_enter <= {$_SERVER['REQUEST_TIME']} AND ppl2grp2subj.ppl_exit > {$_SERVER['REQUEST_TIME']} WHERE ppl2grp2subj.ppl_id = {$_SESSION['ppl_id']} AND ppl.ppl_id = %i AND subj_id = ( SELECT subj_id FROM $kldv.subj WHERE subj_abbrev = 'mt' ) EOQ , $_GET['ppl_id']); if (!$ppl_id) error_system("geen rechten op ppl_id={$_GET['ppl_id']}"); header('Content-type: text/plain'); print_r($_GET); mdb2_exec($db, "DELETE FROM enrollments WHERE ppl_id = $ppl_id AND moment_id = %i AND ( SELECT DATE(NOW()) <= cDate(year, week, dag) FROM moments JOIN $roosterdb.weken USING (week_id) WHERE moment_id = %i ) ", $_GET['moment_id'], $_GET['moment_id']); header("Location: details.php?ppl_id=$ppl_id"); ?>