CODEWITHSUNDEEP
phplaravelormeloquent
Jamie
Jamie

Reputation: 10886

Laravel query latest record

I've this query:

I'm building a forum and I would like to show the latest message that has being posted. I'm doing that like this:

return Forum::with(['users' => function($query){
            $query->select('user.id', 'user.name', 'user.last_name')
}]);

forum model:

/**
 * @return mixed
 */
public function users()
{
    return $this->belongsToMany(User::class, 'message');
}

How do I only receive the latest user. Right now I receive them all.

Thanks a lot!

Upvotes: 0

Views: 1106

Answers (1)

EddyTheDove
EddyTheDove

Reputation: 13259

public function users()
{
    return $this->belongsToMany(User::class, 'message')->orderBy('id', 'desc');
}

If you want to limit the number of users returned, append ->take(10); to take only last 10 users

Upvotes: 1

Related Questions