$data = [
'title' => 'Character',
'character' => $character,
'collection' => $modelCharacterCards
->table('character_cards')
->select('cards.name, character_cards.qty ')
->join('cards', 'character_cards.cardid = cards.id')
->where('character_cards.characterid', $characterid)
->paginate(2),
'pager' => $modelCharacterCards->where('characterid', $characterid)->pager,
];
There are 14 rows returned in this query. The join is 1-1 relationship.
My pager has the right links for pages 1,2,3 and Last on initial load. Only the Next link is bad. The next link is going to page 4 where I would expect page 2. When I go to the last page (page 8), Previous link is going to page 5. Not sure what I am missing here, let me know if you have thoughts, thanks!