View Student Information

0){ while($row = mysql_fetch_array($sql444)){ foreach( $row AS $key => $val ){ $$key = stripslashes( $val ); } // echo $row; // echo $key; // echo $$key; $STStepId = $STStepID; // echo $STStepID; // echo $UserID; // echo $StudentId; } } // ********************************************************************* // $theSQL = "SELECT UserID FROM ststep WHERE STStepID ='$STStepId'"; $theSQL = "SELECT ststep.UserID, step.Step FROM step INNER JOIN ststep ON step.StepID = ststep.StepID WHERE STStepID ='$STStepId'"; $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 = $UserID; $StepName = $Step; // echo $UserID; // echo $StudentId; } } // ************************************************************************ $theStudentID = $StudentId; $sql = mysql_query("SELECT * FROM users WHERE userid='$theStudentID'"); $record_found = mysql_num_rows($sql); if($record_found > 0){ while($row = mysql_fetch_array($sql)){ foreach( $row AS $key => $val ){ $$key = stripslashes( $val ); } // END FOR echo "View Student Information

"; $query="SELECT * FROM reports WHERE (StudentID ='$theStudentID' AND CreditsTOTAL > 0) ORDER BY EndDate DESC LIMIT 1"; // print "$query"; $result=mysql_query($query); $num=mysql_numrows($result); $i=0; while ($i < $num) { $row99=mysql_fetch_array($result); $CC = $row99["CreditsTPGP"]; // print "$CC"; $CO = $row99["CreditsOTHER"]; // print "$CO"; $CT = $row99["CreditsTOTAL"]; $CG = $row99["CreditsGOAL"]; // CODE echo ''; $i++; } // END WHILE INNER LOOP RECORDSET - last report } // END WHILE echo '

STUDENT INFORMATION :

Name : $first_name $last_name

Email : $email_address

Credits Completed (TPGP) : '.$CC.'

Credits Completed (OTHER) : '.$CO.'

Credits Total : '.$CT.'

Credits Goal : '.$CG.'

'; } // END IF else { echo "Session Variables Timed Out - Please login again."; } // ****************************************************************** $list_comp44 = 1; $sql44="SELECT SStepID,SubStep from sstep"; $result44 = mysql_query($sql44) or die("error in SQL"); $sql3="SELECT ststeps.STStepsID, ststeps.STStepID, ststeps.SStepID, ststeps.EntryDate, ststeps.SubValue, ststeps.WorkHoursAssigned, sstep.SubStep FROM ststeps LEFT JOIN sstep ON ststeps.SStepID = sstep.SStepID WHERE ststeps.STStepsID =".$STStepsID; // echo $sql3; $result3 = mysql_query($sql3); $nrows = mysql_num_rows($result3); $row = mysql_fetch_array($result3); $list_comp44 = $row["SStepID"]; $EntryDate = $row["EntryDate"]; $SubValue = $row["SubValue"]; $WorkHoursAssigned = $row["WorkHoursAssigned"]; $STStepsId = $row["STStepsID"]; $STStepId = $row["STStepID"]; echo '

DELETE SUB STEP

'; } ?>

Step	'; echo ""; echo '
Date (yyyy-mm-dd)
Value
Work Hours Assigned