PHP Code:
<?php
include('./global.php');
$events = $DB_site->query("SELECT DATE_FORMAT(eventdate,'%b %d') AS date, 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";
}
?>
Refer to $event[date] for the date output in your template.