classrules.php at PortalXP - Teacher Edition

<?php

require('admin/config.php');
require('admin/connect.php');
include('admin/outputlib.php');

if ($id) {

// query the DB for School Name & District Name
$sql = "select * from teacher, school, district where teacher.teacher_id = $id and school.school_id = teacher.school_id and district.district_id = teacher.district_id";
$result = mysql_query($sql);	
$myrow = mysql_fetch_array($result);

// query the DB for Latest News Item
$sql2 = "select * from teacher where teacher.teacher_id = $id";
$result2 = mysql_query($sql2);
$myrow2 = mysql_fetch_array($result2);

// query the DB for Class Schedule
$sql3 = "select * from periods where periods.teacher_id = $id ORDER BY periodorder";
$result3 = mysql_query($sql3);	

// query the DB for Links
$sql4 = "select * from links where links.teacher_id = $id ORDER BY links.links_id DESC LIMIT 0,5";
$result4 = mysql_query($sql4);

// query the DB for Theme Information
$sql5 = "SELECT topname, topaddress, toprow, classrow, linksrow, contentrow, bottomrow, sidemenu FROM teacher, theme WHERE teacher.teacher_id = $id and teacher.theme_id = theme.theme_id";
$result5 = mysql_query($sql5);	
$myrow5 = mysql_fetch_array($result5);

?>

<HEAD>
<? INCLUDE("portalxp.php")?>

<STYLE>
A:hover
{
    COLOR: #ff3333;
    TEXT-DECORATION: none
}
</STYLE>
</HEAD>

<? INCLUDE("includes/backend_top.php")?>	

<!-- Content Area -->	
					  <table width='425px' BORDER="0" CELLSPACING="0" CELLPADDING="0">
					  <tr>
					  	  <td bgcolor='<?php echo $myrow5["contentrow"] ?>'>
						  <div class='fontwhite'>
						  Classroom Rules<br>
						  </div>
						  </td>
					  </tr>
					  <tr>	  
						  <td>
						   <?php print_output($myrow2["classrules"]) ?>
						  </td>
					  </tr>
					  </table>
	
<? INCLUDE("includes/backend_bottom.php")?>

<?php

} else {

  // Display PortalXP front page
   
?>

Here is the front page.

<?php

}

?>