Joining on four tables.

[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');