mardi 7 avril 2020

How do I take all the values of a single row under the few id s in PHP Laravel?

enter image description here

This is the output of the select query & I used join query from three tables. How do I take all the values of a single row of id=5 and all of the values of a single row of id=7?

$data = DB::table('col3')
       ->join('col2', 'col2.Record_ID', '=', 'col3.Record_ID')
       ->join('col1', 'col1.Record_ID', '=', 'col2.Record_ID') ->select('col1.*', 'col2.*', 'col3.*')
       ->orderBy('col1.Time','desc')         
       ->get();


via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire