PHP Code:
<?php
include('./global.php');
$events = $DB_site->query("SELECT event, eventdate, eventid, subject
FROM calendar_events
WHERE public = 1 AND eventdate >= '".vbdate('Y-m-d',time())."'
ORDER BY eventdate LIMIT 5");
if ($DB_site->num_rows($events)) {
echo "Next Five Events:<br>";
while ($event = $DB_site->fetch_array($events)) {
echo "<a href='calendar.php?s=$session[sessionhash]&action=getinfo&eventid=".$event['eventid']."'>".$event['subject']."</a><br>";
}
} else {
echo "No Events";
}
?>
It should even be Kier approved in terms of quoted array indices but it may be subject to correction.