Joining on four tables.

[eluser]noname525[/eluser]
vv

[eluser]Matalina[/eluser]
Join statements work:

Code:

$this->db->join('Country','Register.country_id = Country.country_id');
$this->db->join('State','Register.state_id = State.state_id');
$this->db->join('City','Register.city_id = City.city_id');
$query = $this->db->get('Register');

[eluser]noname525[/eluser]
vv

[eluser]noname525[/eluser]
vv

[eluser]noname525[/eluser]
vv

[eluser]Unknown[/eluser]
If you only wanna make selects on that query, why not use a view created in MySQL?

[eluser]Matalina[/eluser]
select statements are a string not an array. So you have to take out all those extra quotes and commas

Code:

$this->db->select('country.name AS cname, state.name AS sname, city.name AS ccname, register.id AS rid, register.name AS rname, register.email AS remail');