// session_start();
include 'TPGP_db.php';
// self post data
$Submit = $_POST['Submit'];
$StudentID = $_POST['sid'];
$EntryDate = $_POST['EntryDate'];
$SStepID = $_POST['SStepID'];
$SubValue = $_POST['SubValue'];
$WorkHours = $_POST['WorkHours'];
/* Let's strip some slashes in case the user entered
any escaped characters. */
$Submit = stripslashes($Submit);
$StudentID = stripslashes($StudentID);
$EntryDate = stripslashes($EntryDate);
$SStepID = stripslashes($SStepID);
$SubValue = stripslashes($SubValue);
$WorkHours = stripslashes($WorkHours);
// echo $PHP_SELF
// THIS IS WHERE THE SELF POST FORM GOES
// Define post fields into simple variables
if ($Submit == "Add StudentSubStep") {
$sql2 = "INSERT into ststeps (UserID,EntryDate,SStepID,SubValue, WorkHours) VALUES ('$EnrollmentID','$Evaluation','$EvalDate','$Assignment','$Extras','$Unit','$Lesson')";
mysql_query($sql2);
} else {
// $PHP_SELF as the form action will cause the script to post to itself
$StudentID = $_GET['ID'];
} // END ELSE IF
// this is the QUERY TO RETRIEVE THE DATA FOR THE ITEM
// ********************************************************************************
//$sql = 'SELECT ststeps.SStepID, ststeps.EntryDate, ststeps.SubValue,
//ststeps.UserID, sstep.SubStep, users.first_name, users.last_name' . '
//FROM sstep' . ' LEFT JOIN ( ststeps' . ' LEFT JOIN users
//ON ststeps.UserID = users.userid ) ON sstep.SStepID =
//ststeps.SStepID' . ' WHERE ( ststeps.UserID =18 AND NOT IsNull(
//users.UserID ) ) LIMIT 0, 30';
// $sql="SELECT unit.unitID, unit.classID, classes.ClassName, unit.unit, unit.lesson FROM unit INNER JOIN classes ON unit.classID = classes.ClassId WHERE unit.classID=" .$PostId. " ORDER BY unit.unitID";
$sql = "SELECT ststeps.STStepsID, ststeps.SStepID, ststeps.EntryDate, ststeps.SubValue, ststeps.UserID, sstep.SubStep, users.first_name, users.last_name FROM sstep LEFT JOIN ( ststeps LEFT JOIN users ON ststeps.UserID = users.userid ) ON sstep.SStepID = ststeps.SStepID WHERE ( ststeps.UserID =18 AND NOT IsNull( users.UserID ) )";
$result = mysql_query($sql);
$nrows = mysql_num_rows($result);
print "
';
$RURL = "TPGP_Update.php?ID=" .$StudentID;
print "Click here to return to the other weekly reports for this student!";
// THIS IS WHERE THE SELF POST FORM ENDS
// mysql_close($dbcon);
?>