// session_start(); include 'TPGP_db.php'; // self post data $iCancel = $_POST['Cancel']; $theSubmitAction = $_POST['Submit']; $theClassId = $_POST['theClassId']; $Subject = $_POST['SubjectId']; $ClassName = $_POST['ClassName']; $Description = $_POST['Description']; $LastRevision = $_POST['LastRevision']; $RevisedBy = $_POST['RevisedBy']; $Credits = $_POST['Credits']; $iCancel = stripslashes($iCancel); $theClassId = stripslashes($theClassId); $Subject = stripslashes($Subject); $ClassName = stripslashes($ClassName); $Description = stripslashes($Description); $LastRevision = stripslashes($LastRevision); $RevisedBy = stripslashes($RevisedBy); $Credits = stripslashes($Credits); // echo $PHP_SELF // THIS IS WHERE THE SELF POST FORM GOES // Define post fields into simple variables if (iCancel == "Cancel"){ header("Location: TPGP_EditClasses.php"); } if (($theClassId) && ($ClassName)) { if ($theSubmitAction=="Delete Class") { $sql2 = "DELETE FROM classes WHERE ClassId=" .$theClassId; mysql_query($sql2); $sql3 = "DELETE FROM unit WHERE classID=" .$theClassId; mysql_query($sql3); header("Location: TPGP_EditClasses.php"); } else { header("Location: TPGP_EditClasses.php"); } } else { // $PHP_SELF as the form action will cause the script to post to itself $ClassID = $_GET['ID']; $sql3="SELECT subject.Subject, subject.SubjectID, classes.* FROM classes LEFT JOIN subject ON classes.SubjectId = subject.SubjectID WHERE ClassId=" .$ClassID; // BE SURE TO GO BACK AND LOOK FOR ALL THE RELATED UNITS AND DELETE THEM // $result3 = mysql_query($sql3); $nrows = mysql_num_rows($result3); $row = mysql_fetch_array($result3); echo '