I want to join two tables in my Laravel project but any same field name in two tables i use.
User table:
- id
- name
- gender
Gender table:
- id
- name
So i create join function in Controller like this:
$account = DB::table('users')
->join('genders','genders.id', '=','users.gender')
->select('users.*','genders.*','users.id as users_id','users.name as users_name','genders.id as genders_id','genders.name as genders_name')
->where('users.id',$id)->get()->first();
And in my blade i use this to get field name in users table:
{{ $account->users_name }}
But i got an error notification like this:
Trying to get property 'users_name' of non-object
Anyone can help me how should i do? thanks.