<?PHP
//Filename : edit_minutes.php
//Description : Edit minutes in the database via TinyMCE
//Author : darc
//Last modified : 2006.12.20
include ('../includes/auth_ec.php');
$date = $_POST['date_select'];
include("../includes/db.php");
$sql = "SELECT date, description, body FROM meeting_minutes WHERE date = '$date'";
$result = mysql_query($sql,$connection) or die(mysql_error());
$row = mysql_fetch_array($result);
$minutes = $row['body'];
$description = $row['description'];
?>
<html>
<head>
<title>Gsys :: Edit Minutes from <?PHP echo $date; ?></title>
<script language="javascript" type="text/javascript" src="../tinymce/jscripts/tiny_mce/tiny_mce.js"></script>
<script language="javascript" type="text/javascript">
tinyMCE.init({
mode : "textareas"
});
</script>
</head>
<body>
<br /><br />
<center>
<strong><h2>Edit Minutes</h2></strong>
This form allows you to edit meeting minutes from a specified date. <br />
<form method="post" action="minute_functions.php?cat=update_minutes">
<textarea name="content" cols="100" rows="45"><?PHP echo $minutes; ?></textarea>
</center>
<br /><br /><br />
<center>
<input type="hidden" name="date" value="<?PHP echo $date; ?>">
<strong>Brief Description (60 characters or less): <input type="text" name="description" size="62" maxlength=60 value="<?PHP echo $description; ?>">
<br /><br />
<INPUT TYPE="SUBMIT" NAME="submit" VALUE="Update Minutes"></center>
</body>
</html>