"; echo "

Turning Point at Granita Park

Student Administration System

Add / Edit Subject

"; $sql="SELECT Subject, SubjectID FROM subject"; $result = mysql_query($sql); $nrows = mysql_num_rows($result); if($nrows != 0) { print ""; print ""; print ""; print ""; print ""; print ">"; for($j=0;$j<$nrows;$j++) { $row = mysql_fetch_array($result); $EditURL = "TPGP_EditSubject.php?ID=" . $row['SubjectID']; $DeleteURL = "TPGP_DeleteSubject.php?ID=" . $row['SubjectID']; $ClassesURL = "TPGP_EditClasses.php?ID=" . $row['SubjectID']; print "

FUNCTION		"; print "SubjectID	"; print "Subject
EDIT"; print "	DELETE"; print "	" . $row["SubjectID"]; print "	" . $row["Subject"]; print "\n"; } print "

\n"; echo '

Add New Subject

'; } // END IF greater than one row found inthe class list. } else { // $PHP_SELF as the form action will cause the script to post to itself echo ""; echo "

Turning Point at Granita Park

Student Administration System

Add / Edit Subject

Click here to return to the main administration page!

FUNCTION		"; print "SubjectID	"; print "Subject
EDIT"; print "	DELETE"; print "	" . $row["SubjectID"]; print "	" . $row["Subject"]; print "\n"; } print "

\n"; echo '

Add New Subject

'; } // End If } // END ELSE echo "Click here to return to the Main Administration Page!"; ?>