SQL Join

[eluser]iainco[/eluser]
Hi Randy, thanks for your help.

Code:

function fetchFeeds($categoryID)
{
    $this->db->select('feed.ID, feed.title, user_feed.feedID');
    $this->db->from('feed');
    $this->db->join('user_feed', 'user_feed.feedID = feed.ID AND user_feed.userID = ' . $this->session->userdata('ID'), 'left');
    $this->db->where('feed.categoryID', $categoryID);

    return $this->db->get()->result_array();
}

I found this to work exactly as I need it to... but it doesn't match with what you said.

Thanks