getting data from db give wrong result when echo $row->id....

[eluser]WanWizard[/eluser]
[quote author="digitaldivaradio" date="1282106876"]

Code:

$this->db->select('users.id', 'users.first_name', 'users.last_name', 'users.occupation' ');

and then I get an error when I try to echo out the $row->occupation_title (occupation title is from the occupation table, not users) with the above select.[/quote]

Which is quite logical, you haven't included a field called 'occupation_title' in your select.

You can use

Code:

$this->db->select('users.id AS row_id');

which will create $row->row_id.