Location: PHPKode > projects > Gsys > admin/minutes.php
<?PHP
//Filename : minutes.php
//Description : show all minutes in database with data and brief description
//Author :  darc
//Last modified :  2006.12.20


include("../includes/db.php");
include("../includes/auth.php");

$sql = "SELECT date, description FROM meeting_minutes ORDER BY date DESC";
$result = mysql_query($sql,$connection) or die(mysql_error());
?>
<html>
<head>
<title>Meeting Minutes</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%" valign="top">
<table>
<tr>
<th><strong>Date</strong></th>
<th><strong>Description</strong></th>
</tr>

<?php

//Setup counter
$counter = 1;
//Loop to print out all results
while ($row =mysql_fetch_array($result))
{
$date = $row['date'];
$description = $row['description'];
?>

<tr>
<td class="date_column"><?php echo("<a href=\"view_minutes.php?cat=".$date."\">".$date."</a>");?></td>
<td><?php echo($description);?></td>
</tr>

<?php
} //Close loop
?>

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

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