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


$sql = "SELECT date, description FROM meeting_minutes ORDER BY date DESC";
$result = mysql_query($sql,$connection) or die(mysql_error());
<title>Meeting Minutes</title>
<link href="../includes/index.css" rel="stylesheet" type="text/css">

<body class="body">
<br />
<table width="810" height="626" border="0" align="center" cellpadding="15">
    <td height="128" colspan="2"><img src="../images/eg_banner.gif" width="810" height="172"></td>
    <td width="27%" height="488" valign="top"> <?php include '../includes/nav.inc'; ?></td>
    <td width="53%" valign="top">


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

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

} //Close loop


Return current item: Gsys