dirroot.'/blocks/mis/cfg/config.php'); require_once($CFG->dirroot.'/blocks/mis/lib/lib_facility_db.php'); require_once($CFG->dirroot.'/blocks/mis/lib/moodledb.php'); require_once($CFG->dirroot.'/user/filters/lib.php'); // Diags for $_POST print_r($_POST); $uname = $_POST["uname"]; $tutor = $_POST["tutor"]; $subjectid = $_POST["newoption"]; /** foreach($_POST as $post) { $uname = $post->uname; $tutor = $post->tutor; $subjectid = $post->newoption; } **/ //Lookup options for this year $thisyear = date("Y"); //SQL3 - Lookup options for this year $sql3 = 'SELECT * FROM '.$CFG->prefix.'yr9options_available WHERE subjectid = "'.$subjectid.'"'; // Extract records using SQL1 $optava=get_records_sql($sql3); foreach($optava as $row3) { $subject = $row3->subject; $doubleopt = $row3->doubleopt; } if ($doubleopt = 'y') { $sql4 = 'INSERT INTO '.$CFG->prefix.'yr9options_chosen (`uname` ,`tutor` ,`subject` , `year`) VALUES ("'.$uname.'", "'.$tutor.'", "'.$subject.' - Double Option", "'.$thisyear.'")'; $sql5 = 'INSERT INTO '.$CFG->prefix.'yr9options_chosen (`uname` ,`tutor` ,`subject` , `year`) VALUES ("'.$uname.'", "'.$tutor.'", "'.$subject.' - Double Option", "'.$thisyear.'")'; } else { $sql6 = 'INSERT INTO '.$CFG->prefix.'yr9options_chosen (`uname` ,`tutor` ,`subject` , `year`) VALUES ("'.$uname.'", "'.$tutor.'", "'.$subject.'", "'.$thisyear.'")'; } /** echo '

document.return.submit(); '; **/