I have a script that pulls the latest eventd from my VB, the problem is that the date gets pulled in American rather than European format:
PHP Code:
<?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>";
?>
anyone help me get the date in European Format?
dd-mm-yy
TIA