Sorry, didn't know there was a new reply
Here's the answer
PHP Code:
<?php
require('../global.php');
$events = $DB_site->query("SELECT event, eventdate AS date, 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)) {
$timestring=strtotime($event['date']);
$date=date("l jS F",$timestring);
echo "<li><font size=\"1\">".$date." <a
href='calendar.php?s=$session[sessionhash]&action=getinfo&eventid=".$event['eventid']."'>".$event['subject']."</a> <br>
";
}
} else {
echo "No Events";
}
echo "</ul>";
?>