Update Student Information

0){ while($row = mysql_fetch_array($sql444)){ foreach( $row AS $key => $val ){ $$key = stripslashes( $val ); } // echo $row; // echo $key; // echo $$key; $EnrollmentID = $enrollmentID; // echo $STStepID; // echo $UserID; // echo $StudentId; } } // *********************************************************************** // USE THE ENROLLMENT ID TO GET THE USER ID $theSQL = "SELECT StudentID FROM enrollment WHERE EnrollmentID ='$EnrollmentID'"; $sql444 = mysql_query($theSQL); // echo $theSQL; $record_found = mysql_num_rows($sql444); // echo $record_found; if($record_found > 0){ while($row = mysql_fetch_array($sql444)){ foreach( $row AS $key => $val ){ $$key = stripslashes( $val ); } // echo $row; // echo $key; // echo $$key; $StudentId = $StudentID; // echo $STStepID; // echo $UserID; // echo $StudentId; } } $theStudentID = $StudentId; // echo $StudentId ; // %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% $sql = mysql_query("SELECT * FROM users WHERE userid='$StudentId'"); $record_found = mysql_num_rows($sql); if($record_found > 0){ while($row = mysql_fetch_array($sql)){ foreach( $row AS $key => $val ){ $$key = stripslashes( $val ); } $EnrollmentURL = "TPGP_UpdateEnrollment.php?ID=" . $StudentId; $StepsURL = "TPGP_UpdateSteps.php?ID=" . $StudentId; $ReportsURL = "TPGP_UpdateWeeklyReports.php?ID=" . $StudentId; $ProgramsURL = "TPGP_UpdateWeeklyPrograms.php?ID=" . $StudentId; echo "Update Student Information

Enrollment Steps Reports Programs

STUDENT INFORMATION :

Name : $first_name $last_name

Email : $email_address

"; } // END WHILE } // END IF RECORDS FOUND // ********************************************************************* $sql3="SELECT enrollmentID,evaluation,evaldate,assignment,extras,unit,lesson FROM endetails WHERE endetailID=" .$EndetailID; $result3 = mysql_query($sql3); $nrows = mysql_num_rows($result3); $row = mysql_fetch_array($result3); echo '

Delete Unit / Lesson

'; } ?>

Unit
Lesson
Evaluation
Evaluation Date (yyyy-mm-dd)
Assignment
Extras