Laravel sort data from database

Question

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

Team Ahmed
Team Ahmed
Team Hassan

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

Sandeep Sudhakaran · Accepted Answer · 2019-03-14 13:03:59Z

7

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();

answered Mar 14, 2019 at 13:03

Sandeep Sudhakaran

1,0982 gold badges10 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Laravel sort data from database

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related