Thanks neo
Now another question. I have this code:
Code:
<?PHP
require("./global.php");
$events = $DB_site->query("SELECT eventid, DATE_FORMAT(eventdate,'%M %d') AS eventdate, subject, venue, location FROM calendar_events WHERE public='1' ORDER BY eventdate LIMIT 10");
while ($event = $DB_site->fetch_array($events)) {
echo "<font size=1 face=\"verdana, helvetica\">" . $event['eventdate'] . " <a href=\"$bburl/calendar.php?s=&action=getinfo&eventid=" . $event['eventid'] . "\">" . $event['subject'] . "</a> " . $event['location'] . "</font>";
}
?>
It spits out the dates fine, but since I have it ordered by date, it lists the months alphabetically instead of by calendar order... Is there a way to fix that? :ermm: