DATE_ADD(CURDATE(), INTERVAL -1 DAY) " . "ORDER BY eventdate ASC"; $sql->Query($cmd); if ($sql->rows) { for ($c = 0; $c < $sql->rows; $c++) { $sql->Fetch($c); $r = $sql->data; $eID = $r["eventID"]; $eventdate = $r["date"]; $eventtime = $r["eventtime"]; $location = $r["location"]; $event = $r["event"]; $details = $r["details"]; echo '

'.$eventdate.':
'.$event.'

'; } } else { echo '

No upcoming events listed.

'; } echo '

Events...

'; ?>

Query($cmd); if ($sql->rows) { for ($c = 0; $c < $sql->rows; $c++) { $sql->Fetch($c); $r = $sql->data; $lID = $r["latestID"]; $title = $r["title"]; $ts = date('m/d/Y', $r["ts"]); echo '

'.$ts.':
'.$title.'

'; } } else { echo '

No recent news.

'; } $sql->Close(); echo '

More...

'; ?>