I am running this query,
$this->db->select('news.news_id, news.title, news.article, news.date_posted, news_assets.news_assets_id, news_assets.url')
->from('news_assets')
->join('news', 'news_assets.news_news_id = news.news_id', 'left')
->order_by('news.date_posted', 'DESC');
$query = $this->db->get();
return $query->row_array();
Now this query returns a news article, and it should return any attributed assets from the news assets table, the news assets table has 1:n relationship with news so a news article may have an infinite amount of assets but an asset with only ever have 1 news article.
My question is that when I run this query only one asset for a news article is returned, why would this be?