date blues

[Gary King]

Looks fine to me.

Could you point out which one is incorrect?

[Dave#]

Today at 08:26 PM Gary W said this in Post #11
Looks fine to me.

Could you point out which one is incorrect?

the last one for example

Friday 9th May Coventry (A)

Should say Sunday, I think all the days are wrong in 2004

[Dave#]

did you manage to have a look at this Gary ?

[Gary King]

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>";
?>

[Dave#]

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

[Gary King]

Yep glad I could help