ActiveRecord Expert Needed!

[eluser]davidbehler[/eluser]
Untested!

Code:

function get_many_products($num = 10)
        {
            $this->db->select('*');
            $this->db->from('product_list');
            $this->db->limit($num);
            $query = $this->db->get();
        
            if ( $query->num_rows() > 0 )
            {
                $product_list = $query->result_array();
                foreach($product_list as $key => $product)
                {
                  $this->db->from('productmeta');
                  $this->db->where('product_id', $product['id']);
                  $query = $this->db->get();
                  if($query->num_rows() > 0)
                  {
                    $product_list[$key]['meta_data'] = $query->result_array();
                  }
                  else
                  {
                    $product_list[$key]['meta_data'] = array();
                  }
                }
                return $product_list;
            }
            
            return array();
        }