0){ ?>

Turning Point at Granita Park

Student Administration System

STUDENT ADMINISTRATION

"; $sql="SELECT * FROM users ORDER BY last_name"; $result = mysql_query($sql); $nrows = mysql_num_rows($result); if($nrows != 0) { print ""; print ""; print ""; print ""; print ""; print ""; print ""; print ""; print ""; print ""; print ""; print ""; print ">"; for($j=0;$j<$nrows;$j++) { $row = mysql_fetch_array($result); $EditURL = "TPGP_Edit.php?ID=" . $row['userid']; $DeleteURL = "TPGP_Delete.php?ID=" . $row['userid']; $UpdateURL = "TPGP_Update.php?ID=" . $row['userid']; $ViewURL = "TPGP_AdminViewStudent.php?ID=" . $row['userid']; print "

FUNCTION				"; print "ID	"; print "First Name	"; print "Last Name	"; print "Email	"; print "Login	"; print "Comments	"; print "Create Date	"; print "Last Login	"; print "Active
UPDATE"; print "	EDIT"; print "	VIEW"; print "	DELETE"; print "	" . $row["userid"]; print "	" . $row["first_name"]; print "	" . $row["last_name"]; print "	" . $row["email_address"]; print "	" . $row["username"]; print "	" . $row["info"]; print "	" . $row["signup_date"]; print "	" . $row["last_login"]; print "	" . $row["activated"]; print "\n"; } print "

\n"; print "To Create A New Student, click here.

"; print "To Return to the Administrative Main Menu, click here."; } else{ print "

No Records Located"; print "To Create A New Student, click here."; print "To Return to the Administrative Main Menu, click here."; } // mysql_close($dbcon); } // END IF RECORD FOUND FOR USER ID - to ensure that a member of the system has logged in } // END THE ADMIN USER ID =2 // echo $theStudentID; // echo $theAdminUser; ?>