$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) { list($y1, $m1, $d1) = explode("-", $event["date"]); list($y2, $m2, $d2) = explode("-", $event["end_date"]); $start_date = mktime(0, 0, 0, $m1, $d1, $y1); $end_date = mktime(0, 0, 0, $m2, $d2, $y2); //$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; } }