Location: PHPKode > projects > Gsys > admin/minutes_man.php
<?PHP
//Filename : minutes_man.php
//Description : Administration panel for minutes
//Author :  darc
//Last modified :  2006.12.20


	include '../includes/auth_ec.php';
	include('../includes/db.php');

	$sql = "SELECT date FROM meeting_minutes ORDER BY date DESC";
        $minutes1 = mysql_query($sql,$connection) or die(mysql_error());
	$minutes2 = mysql_query($sql,$connection) or die(mysql_error());
?>

<html>
<head><title>Meeting Minutes Administration</title><link href="../includes/index.css" rel="stylesheet" type="text/css"></head>
<body class="body">
<br />
<table width="810" height="626" border="0" align="center" cellpadding="15">
  <tr> 
    <td height="128" colspan="2"><img src="../images/eg_banner.gif" width="810" height="172"></td>
  </tr>
  <tr> 
    <td width="27%" height="488" valign="top"> <?php include '../includes/nav.inc'; ?></td>
    <td width="53%">
<ol>
	<li><a href="add_minutes.php" target="_blank">Add Minutes</a></li>
	<li><form method="post" action="edit_minutes.php">Edit minutes from:  
		<SELECT name="date_select">
		<?PHP
			while ($row =mysql_fetch_array($minutes1))
			{
				$date = $row['date'];
				echo "<OPTION value=\"$date\">$date\n";
			 }
		?>
		</SELECT>
		<INPUT TYPE="SUBMIT" NAME="submit" VALUE="EDIT!"></form>
		</li>
	<li><form method="post" action="minute_functions.php?cat=delete_minutes"><font color="red"><strong>DELETE</strong></font> minutes from:
                <SELECT name="date_select">
                <?PHP
                        while ($row =mysql_fetch_array($minutes2))
                        {
                                $date = $row['date'];
                                echo "<OPTION value=\"$date\">$date\n";
                         }
                ?>
                </SELECT>
                <INPUT TYPE="SUBMIT" NAME="submit" VALUE="DELETE!"> <br />(better be sure, there is no confirmation...)
		</form>
</ol>


   </td>
  </tr>
</table>

</body>
</html>
Return current item: Gsys