CODEWITHSUNDEEP
phpmysqllaravel
mohamed adel
mohamed adel

Reputation: 715

Laravel sort data from database

Hello i have this function 

 $TableB1 = \DB::table('users')
    ->join('group_user', 'users.id', '=', 'group_user.user_id')
    ->join('groups', 'groups.id', '=', 'group_user.group_id')
    ->select(
       'groups.name as groupname',
       'group_user.user_id as id',
       'users.name as name',
       'users.company_id as companyID'
       )
    ->get();

it get data from db and display the data in view like this

what i want to do is to group the data by group.name so the team field appear in order like
Table

Team Ahmed
Team Ahmed
Team Hassan

but when i use groupBy('group.name') i get an error in laravel

Upvotes: 1

Views: 317

Answers (1)

Sandeep Sudhakaran
Sandeep Sudhakaran

Reputation: 1092

try orderBy().

 $TableB1 = \DB::table('users')
->join('group_user', 'users.id', '=', 'group_user.user_id')
->join('groups', 'groups.id', '=', 'group_user.group_id')
->select(
   'groups.name as groupname',
   'group_user.user_id as id',
   'users.name as name',
   'users.company_id as companyID'
   )->orderBy('groupname')
->get();

Upvotes: 7

Related Questions