Calendar Class: multiple events on one day

[eluser]ehalber[/eluser]
Hi all,

This question has been addressed before here: http://ellislab.com/forums/viewthread/54422/

But, I can't seem to get things working. My question is: how to I get multiple events on each day?

CONTROLLER

Code:

(other stuff) .......

            $year = $this->uri->segment(3);
            $year = ($year > 0) ? $year : date("Y");

            $month = $this->uri->segment(4);
            $month = ($month > 0) ? $month : date("n");
            
            $events = $this->calendarModel->getEvents($year, $month);
            
            $calendar = array();
            
            foreach ($events as $event)
            {
                $calendar[date('d', strtotime($event->date))] = $event->name;
            }
          
            $data['calendar'] = $calendar;
            
            $this->load->view('admin/calendar', $data);

MODEL:

Code:

public function getEvents($year, $month)
    {
        
        $sql = "SELECT *
                FROM (events)
                INNER JOIN event_dates
                ON events.id = event_dates.event_id
                WHERE YEAR(date) = {$year}
                AND MONTH(date) = {$month}";

        $query = $this->db->query($sql);

        if ( $query->result() > 0 )
        {
            return $query->result();
        }
    }

Thanks!