$SQL = “SELECT * FROM minutes WHERE doctype=’Minutes_Trustees’ AND docdate > DATE_SUB(CURDATE(), INTERVAL 5 YEAR)
AND visible = ‘Yes’ ORDER BY docdate DESC”;
$query = mysqli_query($cc_volansing_db, $SQL);
if(mysqli_num_rows($query) > 0) {
print “
From the Past 5 Years:
“;
while ($row = mysqli_fetch_array($query)) {
// Display thumbnail-sized image with link to full-size image in new window
print “
“. $row[‘dochyperlink’] . “
“;}
}
// Close database connection
mysqli_close($cc_volansing_db);
exit;
[/insert_php]
