<HTML>
<BODY>
<?php
$db = mysql_connect("localhost","root");
mysql_select_db("main",$db);
if ($submit) {
if ($id) {
$sql = "UPDATE edit SET
sub='$sub',msg='$msg',name='$name',email='$email',newday='$newday' WHERE id=$id";
} else {
$sql = "INSERT INTO edit (sub,msg,name,email,date,time,newday) VALUES
('$sub','$msg','$name','$email','$date','$time','$newday')";
}
$result = mysql_query($sql);
echo "Record updated/edited!<p>Return to <A href=\"index2.php?page=edit\">$sub</a>.";
} elseif ($delete==areyousure) {
$sql = "SELECT * FROM edit WHERE id=$id";
$result = mysql_query($sql);
echo "Are you sure you want to delete $sub?<p><a
href=$PHP_SELF?page=edit&id=$id&delete=true>Yes</a> | <a
href=$PHP_SELF?page=edit>No</a>";
} elseif ($delete==true) {
$sql = "DELETE FROM edit WHERE id=$id";
$result = mysql_query($sql);
echo "$sub Record deleted!<p><a href=index2.php?page=edit>Return</a>";
} else {
if (!$id && !$edit) {
$result = mysql_query("SELECT * FROM edit ORDER BY time ASC",$db);
while ($myrow = mysql_fetch_array($result)) {
$newday = false ;
$newday = $myrow['newday'] ;
if ($newday) {
printf("<TABLE border=0 cellpadding=0 cellspacing=2 width=%s><TR><TD
align=right class=newsdate width=%s><P style=text-align:
right><b>%s</b></TD></TD></TABLE>", $myrow["width"], $myrow["width"], $myrow["date"]);
}
printf("<font class=newstitle><b><a
href=\"%s?page=edit&edit=yes&id=%s\">%s</a></b></font><font class=newsnfo> - <a
href=mailto:%s>%s</A> @ %s AEST</font><br>", $PHP_SELF, $myrow["id"], $myrow["sub"],
$myrow["email"], $myrow["name"], $myrow["time"]);
printf("%s<br><br>", $myrow["msg"]);
printf("<a
href=\"index2.php?page=edit&id=%s&delete=areyousure\">(DELETE)</a><br>", $myrow["id"]);
}
echo "<P><a href=index2.php?page=edit&edit=yes>ADD A RECORD</a><P>";
}
}
?>
<?php
if ($edit) {
?>
<form method="post" action="index2.php?page=edit">
<?php
if ($page && $id) {
$sql = "SELECT * FROM edit WHERE id=$id";
$result = mysql_query($sql);
$myrow = mysql_fetch_array($result);
$id = $myrow["id"];
$name = $myrow["name"];
$email = $myrow["email"];
$sub = $myrow["sub"];
$msg = $myrow["msg"];
$newday = $myrow["newday"];
$width = $myrow["width"];
?>
<input type=hidden name="id" value="<?php echo $id ?>">
<?php
}
?>
<input type=hidden name="date" value="<?php echo date("l, F, jS Y"); ?>">
<input type=hidden name="time" value="<?php echo date("H:i:s"); ?>">
<input type=hidden name="width" value="100%">
Name:<input type="Text" name="name" value="<?php echo $name ?>"><br>
E-Mail:<input type="Text" name="email" value="<?php echo $email ?>"><br>
Subject:<input type="Text" name="sub" width=50 value="<?php echo $sub ?>">New
Day?<input type="radio" name="newday" value="1">Yes<input type="radio" name="newday"
value="0">No<br>
Message:<textarea name="msg" rows="7" cols="80" wrap="virtual"><?php echo $msg
?></TEXTAREA><br>
<input type="Submit" name="submit" value="Enter information">
</form>
<?php
}
?>
</BODY>
</HTML>
