CODEWITHSUNDEEP
phpcodeigniter
Nisha haridas
Nisha haridas

Reputation: 332

Join more than two tables in codeigniter

I have 4 tables and i want to join there tables together in codeigniter. Is it possible with codeigniters join method?

Upvotes: 2

Views: 5839

Answers (2)

gen_Eric
gen_Eric

Reputation: 227220

If you are using CodeIgniter's Active Record class, you can just use the join method multiple times to join multiple tables.

$this->db->join('table2', 'table2.ID = table1.ID');
$this->db->join('table3', 'table3.ID = table1.ID');
$this->db->join('table4', 'table4.ID = table1.ID', 'left');

Upvotes: 8

Kræn Hansen
Kræn Hansen

Reputation: 1565

I assume that you are talking about joining SQL database tables, is this correct? If so you can always use the CodeIgniter SQL method, see: http://codeigniter.com/user_guide/database/queries.html

Upvotes: 0

Related Questions