Adding Categories....table join?

[eluser]afterspark[/eluser]
Thanks again for the reply. I'm stuck on something simple that I can't get past....

Here is my query

Code:

$this->db->select('x.*', 'y.name AS category');
$this->db->join('articlecategories AS y', 'x.id = y.articleid');
$this->db->join('categories AS z', 'y.categoryid = z.id');
$this->db->where('x.articleSlug', $this->uri->segment(2));
$query2 = $this->db->get('articles AS x');

After this point, when I try to use the row_array() function to retrieve the article data, everything works fine except the category name. Here is an example

Code:

$row2= $query2->row_array();
            
$data['name'] = $row2['articleName'];
$data['description'] = $row2['articleDescription'];
$data['url'] = $row2['articleURL'];
$data['category'] = $row2['category'];

$this->load->view('article_view', $data);

I then use <?=$name?> and so on to display the data in the view. But for some reason I get a "Message: Undefined index: category" when I try to use the category name.

I feel like I'm really close to getting this, and your help have been very much appreciated.