real_escape_string(trim($_POST['term_name']));
$tc=$conn->real_escape_string(trim($_POST['term_code'])); $do=intval($_POST['display_order']);
$conn->query("INSERT INTO result_terms (session_id,term_name,term_code,display_order) VALUES ($sid,'$tn','$tc',$do)");
if($conn->affected_rows>0) $msg="Term added!"; else $err=$conn->error;
}
if (isset($_GET['del'])) { $conn->query("DELETE FROM result_terms WHERE id=".intval($_GET['del'])); $msg="Deleted."; }
$terms=$conn->query("SELECT rt.*,rs.session_name FROM result_terms rt JOIN result_sessions rs ON rt.session_id=rs.id ORDER BY rs.is_active DESC,rt.display_order");
$sessions=$conn->query("SELECT * FROM result_sessions ORDER BY is_active DESC,id DESC");
?>
Exam Terms | Result