All pastes #447747 Raw Edit

Something

public text v1 · immutable
·published 2007-04-19 08:54 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)
              {
                      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);
                      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;
                      }
              }