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 = $UserID; $StepName = $Step; // 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 // ********************************************************************************* $sql4="SELECT StepID,Step from step"; $result4 = mysql_query($sql4) or die("error in SQL"); // $PHP_SELF as the form action will cause the script to post to itself $sql3="SELECT step.StepID, step.Step, ststep.UserID, ststep.SubStepsRequired, ststep.SubStepsComplete, ststep.WorkHoursRequired, ststep.WorkHoursComplete, ststep.EntryDate FROM step RIGHT JOIN ststep ON step.StepID = ststep.StepID WHERE STStepID=" .$STStepID; // echo $sql3; $result3 = mysql_query($sql3); $nrows = mysql_num_rows($result3); $row = mysql_fetch_array($result3); // echo $row["UserID"]; // echo $row["STStepID"]; $list_comp = $row["StepID"]; echo '

Update STEP

'; } ?>

Step	'; echo '"; echo '
SubSteps Required
SubSteps Complete
Work Hours Required
Work Hours Complete