Join Query Help

[eluser]Lee.[/eluser]
and my controller:

Code:

<?php
class News extends CI_Controller {

public function __construct()
{
parent::__construct();
$this->load->model('news_model');
}
    
    function index()
    {
        // Grab our view data from the blog model.
        $data['article_entries'] = $this->news_model->get_news();
        
        // Load the views.
  $this->load->view('templates/header');
        $this->parser->parse('news/index', $data);
  $this->load->view('templates/footer');
    }

public function view($slug)
{
        // Grab our view data from the blog model.
        $data['article_entries'] = $this->news_model->get_news($slug);
        
        // Load the views.
  $this->load->view('templates/header');
        $this->parser->parse('news/view', $data);
  $this->load->view('templates/footer');
}



public function create()
{
$this->load->helper('form');
$this->load->helper('ckeditor');
$this->load->library('form_validation');


$data['title'] = 'Create a news item';

$this->form_validation->set_rules('title', 'Title', 'required');
$this->form_validation->set_rules('text', 'text', 'required');

if ($this->form_validation->run() === FALSE)
{
  $this->load->view('templates/header', $data);
  $this->load->view('news/create');
  $this->load->view('templates/footer');
  
}
else
{
  $this->news_model->set_news();
  $this->load->view('news/success');
}
}

}