CodeIgniter Forums - Search Results

Search Results

Thread: How to get data from 2 related tables in the same controller?
Post: RE: How to get data from 2 related tables in the s...

neuron Wrote: (07-09-2019, 11:50 PM) -- PHP Code: -- $this->db->select('d.*, o.*') ->from('departments d') ->join('occupations o', 'o.department_id = d.department_id', 'LEFT') -- Simple join i...

Thread: How to get data from 2 related tables in the same controller?
Post: How to get data from 2 related tables in the same ...

I'm trying to get data from 2 DB tables that are related. Departments and Functions: Each Department has multiple Functions. I want to show all data in an accordion on the same page. Until now, the ...