Quote:
Today at 01:56 AM Gary W said this in Post #14
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>";
?>
|
excellent - thanks a million Gary