[del]') afkorting FROM invigilators JOIN $kldv.ppl USING (ppl_id) EOQ ); $weken = mdb2_query($db, <<'), CONCAT('')) ma, IF( ( SELECT COUNT(enrollment_id) FROM enrollments JOIN moments USING (moment_id) WHERE moments.week_id = weken.week_id AND dag = 'di' ), CONCAT(''), CONCAT('')) di, IF( ( SELECT COUNT(enrollment_id) FROM enrollments JOIN moments USING (moment_id) WHERE moments.week_id = weken.week_id AND dag = 'wo' ), CONCAT(''), CONCAT('')) wo, IF( ( SELECT COUNT(enrollment_id) FROM enrollments JOIN moments USING (moment_id) WHERE moments.week_id = weken.week_id AND dag = 'do' ), CONCAT(''), CONCAT('')) do, IF( ( SELECT COUNT(enrollment_id) FROM enrollments JOIN moments USING (moment_id) WHERE moments.week_id = weken.week_id AND dag = 'vr' ), CONCAT(''), CONCAT('')) vr FROM $roosterdb.weken EOQ ); if (isset($_GET['week_id']) && $_GET['week_id']) { $week_id = mdb2_single_val($db, "SELECT week_id FROM $roosterdb.weken WHERE week_id = %i", $_GET['week_id']); $where = 'WHERE week_id = '.$week_id; } else { $week_id = '0'; $where = ''; } $weekselect = mdb2_single_val($db, <<\n\n', GROUP_CONCAT(CONCAT('', week, '\n')), '') FROM $roosterdb.weken EOQ ); $aanmeldingen = mdb2_query($db, <<select').change(function () { $('#select').submit(); }); //$('#su').focus(); $('#su').autocomplete({ source: "search.php", minLength: 4, select: function (event, ui) { if (ui.item) $('#su').val(ui.item.id); // set autocomplete ID } }); }); EOS , "Adminpagina"); ?>

Switch user

Surveillanten

Momenten

Aanmeldingen