Laravel。 我无法从列中读取数据

Question

I have a problem. Needs to get the first date of creation of data in the table by the currently logged in user.

Working example:

$howMuchIPlay = Game::all('user_id')->where('user_id', '=', Auth::user()->id)->count();

Not working example:

$firstVoteInGame = Game::all('created_at')->first()->where('user_id','=', Auth::user()->id);

When I use count() function I get value 38. This is all the rows for the user, but I want to get only the earliest (first). How can I do this?

Sorry for my english and thank you in advance for help.

Answer 1

$firstVoteInGame = Game::where('user_id', '=', Auth::user()->id)->oldest()->first();

This will get the earliest (oldest) record from the current authenticated user.