$events = $db->getAll("SELECT idevent, title, description, date, end_date FROM `site_events` WHERE DATEDIFF(CURDATE(), date) <= 1"); if (PEAR::isError($events)) die($events->getMessage()); foreach ($events as $event) { $start_date = mktime(0, 0, 0, date("m", strtotime($event["date"])), date("d", strtotime($event["date"])), date("Y", strtotime($event["date"]))); $end_date = mktime(0, 0, 0, date("m", strtotime($event["end_date"])), date("d", strtotime($event["end_date"])), date("Y", strtotime($event["end_date"]))); while ($start_date < $end_date); { $specialDays[] = new Calendar_Day(date("Y", $start_date), date("m", $start_date), date("d", $start_date)); $start_date = $start_date + 60*60*24; } }