Retrieving users profile and displaying it.

[eluser]Pedroshow[/eluser]

Code:

function user_profile($id) {
$this->db->select('*');
$this->db->from('users');
$this->db->join('profile', 'users.id = profile.id','left');
$this->db->where('users.id', $id);
$query = $this->db->get();
        
return $query->result();
}