// session_start(); include 'TPGP_db.php'; // self post data $iCancel = $_POST['Cancel']; $theClassId = $_POST['theClassId']; $Subject = $_POST['SubjectId']; $ClassName = $_POST['ClassName']; $Description = $_POST['Description']; $LastRevision = $_POST['LastRevision']; $RevisedBy = $_POST['RevisedBy']; $Credits = $_POST['Credits']; $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 $iCancel = stripslashes($iCancel); if ($iCancel == "Cancel"){ header("Location: TPGP_EditClasses.php"); } if (($Subject) && ($ClassName)) { $sql2 = "UPDATE classes SET SubjectId='$Subject',ClassName='$ClassName',ClassDescription='$Description',LastRevision='$LastRevision',RevisedBy='$RevisedBy',Credits ='$Credits' WHERE ClassId=" .$theClassId; mysql_query($sql2); 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; $result3 = mysql_query($sql3); $nrows = mysql_num_rows($result3); $row = mysql_fetch_array($result3); $list_comp = $row["SubjectID"]; $sql4="SELECT SubjectID,Subject from subject"; $result4 = mysql_query($sql4) or die("error in SQL"); echo '