php - How to join two tables in Codeigniter -

i try join 2 tables , output result:

in model:

$this->db->select('*'); $this->db->from('news'); $this->db->join('authors', 'authors.id = news.author_id');

in view files:

foreach($item $row):     echo $row->id; endforeach;

when run code above, output id column authors table. question how echo id column news table?

both news , author tables have column named id.

try echo $row->author_id

it seems field want in news table author_id instead of id.

edit otherwise can use as sql keyword in select statement give different name field.

$this->db->select('*, news.id my_news_id');

and do, echo $row->my_news_id

TY