<?php include('../global.php'); $events = $DB_site->query("SELECT event, eventdate, eventid, subject FROM calendar_events WHERE public = 1 AND eventdate >= NOW() ORDER BY eventdate LIMIT 8"); if ($DB_site->num_rows($events)) { echo "<ul>"; while ($event = $DB_site->fetch_array($events)) { echo "<li><font size=\"1\">".$event['eventdate']." <a href='calendar.php?s=$session[sessionhash]&action=getinfo&eventid=".$event['eventid']."'>".$event['subject']."</a> <br> "; } } else { echo "No Events"; } echo "</ul>"; ?>