If laravel 4.2 see:
http://laravel.io/forum/12-15-2014-paginator-appends-array-not-working
if laravel 5 see:
http://laravel.io/forum/11-13-2014-laravel-5-pagination
Test this by replacing paginate(15) with get to see if your query is correctly passing results.
Try getting a count of the results and then try the ->skip($offset)->take($perpage)->get();
Solved it...
I dropped the following join it the query.
->join('games', function($join)
{
$join->on('tournaments.id', '=', 'games.tournament_id')
->where('games.game_type_id', '=', '1');
})
Worked fine.
Thanks
That was one yek of a query.
Do see this if you install L5:
http://laravel.io/forum/11-13-2014-laravel-5-pagination
I was being really dumb here. I replaced those lines by:
->join('games', 'tournaments.id', '=', 'games.tournament_id')
->where('games.game_type_id', '=', '1');
Sign in to participate in this thread!
The Laravel portal for problem solving, knowledge sharing and community building.
The community