[eluser]TheFuzzy0ne[/eluser]
Add this to the top of the method or the controller constructor:
Code:
$this->output->enable_profiler(TRUE);
This will allow you to see the queries being executed, so long as there's no fatal error triggered before the final output is sent to the browser.
I
think you're problem might have something to do with your FROM clause. I think it might work if you do this:
Code:
$this->db->select('job_data.job_data_id, a_techs.tech_number, job_data.date, job_data.account_num, job_data.c_address, job_data.c_apt, job_data.job_status');
$this->db->from('job_data');
$this->db->join('a_techs', 'job_data.tech_id = a_techs_a_techs_id', 'INNER');
$this->db->limit($per_page);
if ($this->uri->segment(3) !== FALSE)
{
$this->db->offset($this->uri->segment(3));
}
$query = $this->db->get();