All pastes #447741 Raw Edit

Anonymous

public text v1 · immutable
·published 2007-04-19 08:41 UTC
rendered paste body
	$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;
		}
	}