fetchRow(MDB2_FETCHMODE_ASSOC))) { $select_add .= <<' $concat_end v{$row['eff_question_id']} EOQ; $join_add .= <<seek(); $leerlingen = mdb2_query($db, <<' $concat_cont ppl_forename $concat_cont ' ' $concat_cont ppl_prefix $concat_cont ' ' $concat_cont ppl_surname $concat_cont ' ' $concat_cont ' (' $concat_cont ppl_login $concat_cont ';' $concat_cont grp_name $concat_cont ')' $concat_end leerling $select_add FROM ppl2grp2subj JOIN grp2subj ON grp2subj.grp2subj_id = ppl2grp2subj.grp2subj_id JOIN subj ON subj.subj_id = grp2subj.subj_id JOIN grp ON grp.grp_id = grp2subj.grp_id JOIN eff_meeting2grp ON eff_meeting2grp.grp_id = grp.grp_id AND eff_meeting_id = '%i' JOIN ppl2grp ON ppl2grp.grp_id = grp2subj.grp_id AND ppl2grp.ppl_enter <= {$_SERVER['REQUEST_TIME']} AND ppl2grp.ppl_exit > {$_SERVER['REQUEST_TIME']} JOIN ppl ON ppl.ppl_id = ppl2grp.ppl_id $join_add WHERE ppl2grp2subj.ppl_id = {$_SESSION['ppl_id']} AND ppl2grp2subj.ppl_enter <= {$_SERVER['REQUEST_TIME']} AND ppl2grp2subj.ppl_exit > {$_SERVER['REQUEST_TIME']} AND subj_abbrev = 'mt' ORDER BY ppl_surname, ppl_forename, ppl_prefix EOQ , $_GET['meeting_id']); $testleerlingen = mdb2_query($db, <<' $concat_cont ppl_forename $concat_cont ' ' $concat_cont ppl_prefix $concat_cont ' ' $concat_cont ppl_surname $concat_cont ' (' $concat_cont ppl_login $concat_cont ')' $concat_end header, $concat_begin '' $concat_cont $group_concat_d(vragen $group_concat_d_sep '') $concat_cont '

vraag	stellen?

' $concat_end content FROM ( SELECT ppls.ppl_id, $concat_begin '' $concat_cont eff_question_text $concat_cont '' $concat_cont '' $concat_end vragen FROM ( SELECT ppl2grp.ppl_id FROM ppl2grp2subj JOIN grp2subj ON grp2subj.grp2subj_id = ppl2grp2subj.grp2subj_id JOIN subj ON subj.subj_id = grp2subj.subj_id JOIN grp ON grp.grp_id = grp2subj.grp_id JOIN eff_meeting2grp ON eff_meeting2grp.grp_id = grp.grp_id AND eff_meeting_id = %i JOIN ppl2grp ON ppl2grp.grp_id = grp2subj.grp_id AND ppl2grp.ppl_enter <= {$_SERVER['REQUEST_TIME']} AND ppl2grp.ppl_exit > {$_SERVER['REQUEST_TIME']} WHERE ppl2grp2subj.ppl_id = {$_SESSION['ppl_id']} AND ppl2grp2subj.ppl_enter <= {$_SERVER['REQUEST_TIME']} AND ppl2grp2subj.ppl_exit > {$_SERVER['REQUEST_TIME']} AND subj_abbrev = 'mt' ) AS ppls JOIN eff_questions ON 1=1 LEFT JOIN eff_q2m2p ON eff_q2m2p.ppl_id = ppls.ppl_id AND eff_q2m2p.eff_question_id = eff_questions.eff_question_id AND eff_q2m2p.eff_meeting_id = %i ) AS vragen JOIN ppl ON ppl.ppl_id = vragen.ppl_id GROUP BY ppl.ppl_id, ppl_forename, ppl_prefix, ppl_login, ppl_surname ORDER BY ppl.ppl_surname, ppl.ppl_prefix, ppl.ppl_forename EOQ , $_GET['meeting_id'], $_GET['meeting_id']); if (!($row = $testleerlingen->fetchRow())) error_user('Geen leerlingen', 'Er zijn geen leerlingen in deze bespreking waarvoor je vragen moet opgeven'); //$leerlingen->seek(); html_start(); ?>

Leerlingen