$yy = (($year) && is_numeric($year)) ? $year : date("Y"); $mm = (($month) && is_numeric($month)) ? $month : date("m"); $first_day_month = "{$yy}-{$mm}-01"; $first_day_next_month = "{$yy}-{intval($mm) + 1}-01"; $events = $db->getAssoc("SELECT DISTINCT idevent, title, `date`, end_date FROM `site_events` WHERE (`date`>='{$first_day_month}' AND `date`<'{$first_day_next_month}') OR (`end_date`>='{$first_day_month}' AND `end_date`<'{$first_day_next_month}') OR (`date`<'{$first_day_month}' AND `end_date`>='{$first_day_next_month}') ORDER BY `date` ASC");