";
$sql="SELECT unit.unitID, unit.classID, classes.ClassName, unit.unit, unit.lesson FROM unit INNER JOIN classes ON unit.classID = classes.ClassId WHERE unit.classID=" .$PostId. " ORDER BY unit.unitID";
$result = mysql_query($sql);
$nrows = mysql_num_rows($result);
$sql99="SELECT classes.classID, classes.ClassName FROM classes WHERE ClassId=" .$PostId;
$result99 = mysql_query($sql99);
$nrows99 = mysql_num_rows($result99);
for($j99=0;$j99<$nrows99;$j99++)
{
$row99 = mysql_fetch_array($result99);
}
$class_id = $row99["classID"];
$class_name = $row99["ClassName"];
print "Class : " . $row99["ClassName"];
print " - Edit Units";
print "
";
if($nrows != 0)
{
print "";
print "";
print "| FUNCTION | ";
print "";
print "Class | ";
print "";
print "Unit Name | ";
print "";
print "Lesson | ";
print "
>";
for($j=0;$j<$nrows;$j++)
{
$row = mysql_fetch_array($result);
$EditURL = "TPGP_EditUnit.php?ID=" . $row['unitID'];
$DeleteURL = "TPGP_DeleteUnit.php?ID=" . $row['unitID'];
print "| EDIT";
print " | DELETE";
print " | " . $row["ClassName"];
print " | " . $row["unit"];
print " | " . $row["lesson"];
print "\n";
}
print " |
\n";
// *************************************************
echo '';
// *************************************************
} // 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
$ClassID = $_GET['ID'];
echo "";
$sql="SELECT unit.unitID, unit.classID, classes.ClassName, unit.unit, unit.lesson FROM unit INNER JOIN classes ON unit.classID = classes.ClassId WHERE unit.classID=" .$ClassID. " ORDER BY unit.unitID";
$result = mysql_query($sql);
$nrows = mysql_num_rows($result);
$sql99="SELECT classes.classID, classes.ClassName FROM classes WHERE ClassId=" .$ClassID;
$result99 = mysql_query($sql99);
$nrows99 = mysql_num_rows($result99);
for($j99=0;$j99<$nrows99;$j99++)
{
$row99 = mysql_fetch_array($result99);
}
$class_id = $row99["classID"];
$class_name = $row99["ClassName"];
print "Class : " . $row99["ClassName"];
print " - Edit Units";
print "
";
// print $class_id $class_name
if($nrows != 0)
{
print "";
print "";
print "| FUNCTION | ";
print "";
print "Class | ";
print "";
print "Unit Name | ";
print "";
print "Lesson | ";
print "
>";
for($j=0;$j<$nrows;$j++)
{
$row = mysql_fetch_array($result);
$EditURL = "TPGP_EditUnit.php?ID=" . $row['unitID'];
$DeleteURL = "TPGP_DeleteUnit.php?ID=" . $row['unitID'];
print "| EDIT";
print " | DELETE";
print " | " . $row["ClassName"];
print " | " . $row["unit"];
print " | " . $row["lesson"];
print "\n";
}
print " |
\n";
// print "To Create A New Class, click here.";
} // END IF GREATER THAN ONE ROW FOUND IN CLASS LIST
echo '';
}
$RtURL = "TPGP_EditClasses.php";
print " Click Here to return to the Class.";
?>
|