'."\n";
$workshops = mdb2_query($db, <<= ws_workshop_capacity THEN 1 ELSE 0 END disabled,
CASE WHEN e2.ppl_id IS NOT NULL THEN 1 ELSE 0 END selected
FROM ws_workshops
LEFT JOIN ws_enlistments ON ws_enlistments.ws_event_id = 1 AND ws_enlistments.ws_workshop_id = ws_workshops.ws_workshop_id AND ws_enlistments.ws_round = $i
LEFT JOIN ws_enlistments AS e2 ON e2.ws_event_id = 1 AND e2.ws_workshop_id = ws_workshops.ws_workshop_id AND e2.ws_round = $i AND e2.ppl_id = {$_SESSION['ppl_id']}
WHERE ws_workshops.ws_event_id = 1
GROUP BY ws_workshop_title, ws_workshops.ws_workshop_id, ws_workshop_capacity, e2.ppl_id
ORDER BY ws_workshops.ws_workshop_id
EOQ
);
while (($option = $workshops->fetchRow(MDB2_FETCHMODE_ASSOC))) {
$options[$i] .= ''."\n";
}
$options[$i] .= "";
}
html_start(); ?>
Hier volgt een overzicht van de workshops die worden gegeven.