CODEWITHSUNDEEP
laraveleloquent
Saliou MBALO
Saliou MBALO

Reputation: 169

Get the last entry in laravel

How can I display the last entry in my blade. I have this request:

@foreach(($listContrat = \App\Stagiaire::join('carrieres', 'stagiaires.id', '=',  'carrieres.stagiaire_id')
    ->where('stagiaires.id', $id)
    ->OrderBy('id','desc')
    ->take(1)
    ->get())  
     as $key => $car)

I have this error message with this query

SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'created_at' in order clause is ambiguous (SQL: select * from stagiaires

Upvotes: 0

Views: 54

Answers (1)

Saliou MBALO
Saliou MBALO

Reputation: 169

Thanks freedomn-m

The solution is:

@foreach(($listContrat = \App\Stagiaire::join('carrieres', 'stagiaires.id', 
'=', 'carrieres.stagiaire_id')
                        ->where('stagiaires.id', $id)- 
>OrderBy('carrieres.id','Desc')->take(1)->get())  as $key => $car)

Upvotes: 0

Related Questions