Not pretty code, not optimized code. But it does pull events from only the public folder for use on my homepage. No warranty expressed or implied...use at own risk...your mileage may vary.
<?
$fudgedate = strtotime("yesterday");
//$eventdate = mktime($yesterday);
$events = mysql_query("SELECT * FROM event where dateline_from = '$fudgedate' or dateline_from > '$fudgedate' and recurring !=3 and calendarid = 1 order by dateline_from asc limit 8") or die("oops3");
$eventrow = mysql_fetch_array($events);
while ( $rowevents = mysql_fetch_array($events) ) {
echo "<a href='http://sitename.com/forum/calendar.php?do=getinfo&e=" . $rowevents['eventid'] ."'>";
echo $rowevents['title'];
echo "</a> ";
if ($rowevents['recurring'] == 0 and $rowevents['dateline_to'] == 0) {
$fixdate = ($rowevents['dateline_from'] + 86400);
}
else {
$fixdate = $rowevents['dateline_from'] ;
}
echo date("D M j",$fixdate);
echo "<br>";
}
?>
It has a bit of trouble with some of the ranged date events, but it's good enough for what I use it for. If you improve it, post it back up here...
Cheers,
Mark