$_SERVER['REQUEST_TIME']) error_user('Beantwoorden nog gesloten', 'Deadline voor het selecteren van vragen door de mentor is nog niet verstreken'); $vragen = mdb2_query($db, <<vraag01234X' $concat_cont $group_concat_d(vragen $group_concat_d_sep '') $concat_cont '' $concat_end content FROM ( SELECT ppls.ppl_id, ppls.grps, $concat_begin '' $concat_cont eff_question_text $concat_cont '' $concat_cont '' $concat_cont '' $concat_cont '' $concat_cont '' $concat_cont '' $concat_cont '' $concat_cont '' $concat_cont '' $concat_cont '' $concat_cont '' $concat_cont '' $concat_cont '' $concat_end vragen FROM ( SELECT ppl_id, $group_concat_d( $concat_begin grp_name $concat_cont '/' $concat_cont subjs $concat_end $group_concat_d_sep ';') grps FROM ( SELECT grp2subj.grp_id, $group_concat(subj_abbrev) subjs FROM ppl2grp2subj JOIN grp2subj ON grp2subj.grp2subj_id = ppl2grp2subj.grp2subj_id JOIN subj ON subj.subj_id = grp2subj.subj_id WHERE ppl_id = {$_SESSION['ppl_id']} AND ppl2grp2subj.ppl_enter <= {$_SERVER['REQUEST_TIME']} AND ppl2grp2subj.ppl_exit > {$_SERVER['REQUEST_TIME']} GROUP BY grp_id, subj_abbrev ) AS subjs JOIN grp ON grp.grp_id = subjs.grp_id JOIN ppl2grp ON ppl2grp.grp_id = grp.grp_id AND ppl2grp.ppl_enter <= {$_SERVER['REQUEST_TIME']} AND ppl2grp.ppl_exit > {$_SERVER['REQUEST_TIME']} GROUP BY ppl_id ) AS ppls JOIN eff_q2m2p ON eff_q2m2p.ppl_id = ppls.ppl_id AND eff_meeting_id = %i JOIN eff_questions ON eff_questions.eff_question_id = eff_q2m2p.eff_question_id LEFT JOIN eff_responses ON eff_responses.eff_q2m2p_id = eff_q2m2p.eff_q2m2p_id AND eff_responses.ppl_id = {$_SESSION['ppl_id']} ) AS vragen JOIN ppl ON ppl.ppl_id = vragen.ppl_id GROUP BY ppl.ppl_id, ppl_forename, ppl_prefix, ppl_login, grps, ppl_surname EOQ , $_GET['meeting_id']); if (!($row = $vragen->fetchRow(MDB2_ASSOC))) error_user("Geen leerlingen", "Er zijn geen leerlingen van jou over wie informatie wordt gevraagd"); html_start(); ?>

Hieronder de leerlingen over wie informatie wordt gevraagd.
0 = slecht/negatief, 4 = goed/positief, X= nvt/geen informatie/niet ingevuld.

{$row[0]}

{$row[1]}\n"); } while (($row = $vragen->fetchRow(MDB2_ASSOC))); ?>