switch ($event) {
case “TAK”:
$sql = “SELECT DISTINCT _TAK FROM questionnaire WHERE _TEMPLATE = ‘$questionnaire’ AND _VERSION = ‘$version’ AND _FINAL = ” “;
$db = new MysqliDb(‘CES’);
$selectStatus = $db->rawQuery($sql);
break;
case “FIN”:
$sql = “SELECT DISTINCT _TAK FROM questionnaire WHERE _TEMPLATE = ‘$questionnaire’ AND _VERSION = ‘$version’ AND _FINAL = ‘Y’ “;
$db = new MysqliDb(‘CES’);
$selectStatus = $db->rawQuery($sql);
break;
default:
echo “Fout / Fault”;
}