Unnamed

public function dailyEventCount($month)
    {
        $db          =& $this->calendar->getDatabaseConnection();
        $days        = $month->fetchAll();
        $start_bound = date('Y-m-d', $days[1]->getTimestamp());
        $end_bound   = date('Y-m-d', $days[count($days)]->getTimestamp());
        $sql         = "SELECT DATE_FORMAT(eventdatetime.starttime,'%m-%d') AS day,
                               count(*) AS events
		                FROM calendar_has_event,eventdatetime 
		                WHERE calendar_has_event.calendar_id={$this->calendar->id}
		                AND (calendar_has_event.status ='posted'
                             OR calendar_has_event.status ='archived')
		                AND calendar_has_event.event_id = eventdatetime.event_id 
		                AND eventdatetime.starttime >= '$start_bound 00:00:00'
						AND eventdatetime.starttime <= '$end_bound 23:59:59'
		                GROUP BY day;";
        $res         =& $db->queryCol($sql);
        return $res;
    }