<?PHP
require('config.php');
require('connect.php');
?>
<TITLE><?php echo $domain ?> - Edit Classrules</TITLE>
<? INCLUDE("top-mini.php")?>
<link REL="stylesheet" TYPE="text/css" HREF="../portalxp.css">
<h3>Edit Classrules In Database:</h3><p>
<?php
// query the DB
$sql = "SELECT * FROM teacher WHERE teacher_id=$id";
$result = mysql_query($sql);
$myrow = mysql_fetch_array($result);
if (isset($submit)) {
//process form
$sql2 = "UPDATE teacher SET classrules='$classrules' WHERE teacher_id=$id";
$result = mysql_query($sql2);
echo "Thank you. Your information has been updated.\n";
} else {
//display form
$sql3 = "SELECT * FROM teacher WHERE teacher_id = $id";
$result3 = mysql_query($sql3);
$myrow3 = mysql_fetch_array($result3);
?>
<form method="post">
<table width=500px border=0>
<tr>
<td>Teacher ID:
<td><?php echo $myrow["teacher_id"] ?> - <?php echo $myrow3["lastname"] ?>, <?php echo $myrow3["firstname"] ?>
<tr>
<td>Classrules:
<td><textarea rows="5" cols="55" id="text4" name="classrules" value="none"><?php echo $myrow["classrules"] ?></textarea>
</table>
<input type="Submit" name="submit" value="Enter Information">
<hr size="1">
<center><b>Formatting</b></center>
<pre>
<b>[b]...[/b]</b> Bold
<b>[i]...[/i]</b> Italics
<b>[pre]...[/pre]</b> Preformatted
<b>[indent]...[/indent]</b> Indented Blocks (blockquote)
<b>[link="..."]...[/link]</b> Links (javascript is not permitted)
</pre>
</form>
<?php
} //end if
?>
<? INCLUDE("bottom.php")?>