'events',
'where' => mysql_escapef('MONTH(date) = ? AND YEAR(date) = ?', $cMonth, $cYear),
));
// organize events into an array indexed by 'day', each element being a list of events on that day
$eventsByDay = array();
foreach ($eventsRecords as $event) {
$day = intval(date('d', strtotime($event['date'])));
if (!array_key_exists($day, $eventsByDay)) { $eventsByDay[$day] = array(); }
$eventsByDay[$day][] = $event;
}
?>
|
|
| Sunday |
Monday |
Tuesday |
Wednesday |
Thursday |
Friday |
Saturday |
\n";
if($i < $startday) {
echo " | \n";
}
else {
$day = $i - $startday + 1;
echo "". $day . " ";
// check if there are any events for this day
if (array_key_exists($day, $eventsByDay)) {
// list all events for this day
foreach ($eventsByDay[$day] as $record) {
?>
\n";
}
if(($i % 7) == 6 ) echo "\n";
}
?>
| |