Questions regarding <dl> in CI.

[eluser]überfuzz[/eluser]
[quote author="obiron2" date="1252082318"]If your array is only 2 levels deep, you may find it easier to fetch the years from the database into an array using a SELECT DISTINCT
and then append the event data into each array element using another db query with the year as a filter.Obiron[/quote]

I think I get the idea... Could you give me a hint on how I should write the query? This is a part of the model I was referring to earlier.

Code:

function get_array_to_dl($table_one, $column_one, $table_two,$coulmn_two,$link_column_one, $link_column_two,$order)
    {
        $this->db->select($table_one.'.'.$column_one.' AS when');
        $this->db->select($table_two.'.'.$coulmn_two.' AS event');
        $this->db->from($table_one);
        $this->db->join($table_two, $table_two.'.'.$link_column_two.' = '.$table_one.'.'.$link_column_one);

        $this->db->order_by($table_one.'.'.$link_column_one, $order);
    //etc...
    }