@php $cnt = 1; $taskassigned = DB::table('tm_project_member')->select('master_menu_level_1.menu_name', 'description', 'priority', 'target_dt') ->LEFTJOIN('users', 'tm_project_member.user_id', '=', 'users.id') ->LEFTJOIN('tm_project_member_task', 'tm_project_member.id', '=', 'tm_project_member_task.pro_mem_id') ->LEFTJOIN('master_menu_level_1', 'tm_project_member.project_id', '=', 'master_menu_level_1.id') ->where('tm_project_member.user_id', '=', $user->user_id) ->orderBy('master_menu_level_1.menu_name','asc')->get(); $nm = ""; foreach($taskassigned as $assigns){ @endphp @php if($nm != $assigns->menu_name){ echo ""; echo ""; $cnt++; }else{ echo ""; echo ""; } $nm = $assigns->menu_name; @endphp @php } @endphp

No.	Project	Description	Priority	Target Date
".$cnt."	".$assigns->menu_name."			{{ $assigns->description }}	{{ $assigns->priority }}	{{ date("d-m-Y",strtotime($assigns->target_dt)) }}