Update Student Information

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 classes.ClassName, enrollment.ClassID, enrollment.StudentID, enrollment.FinalGrade, enrollment.CreditsEarned, enrollment.StartDate, enrollment.EndDate, enrollment.Status FROM enrollment INNER JOIN classes ON enrollment.ClassID = classes.ClassId WHERE enrollment.EnrollmentID=" .$EnrollmentID; $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 '

Edit Enrollment

'; } ?>

CLASS
Start Date (yyyy-mm-dd)
End Date (yyyy-mm-dd)
Credits Earned
Final Grade
Status