# Database outputting results twice per page (using pagination

**URL:** <https://www.ruby-forum.com/t/database-outputting-results-twice-per-page-using-pagination/104548>\
**Category:** Rails\
**Created:** [May 19, 2007, 5:19am UTC](https://www.ruby-forum.com/t/database-outputting-results-twice-per-page-using-pagination/104548 "2007-05-19T05:19:51Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![casper\_the\_ghost](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/58956e/32.png) [@casper\_the\_ghost](https://www.ruby-forum.com/u/casper_the_ghost)\
**Post date:** [May 19, 2007, 5:19am UTC](https://www.ruby-forum.com/t/database-outputting-results-twice-per-page-using-pagination/104548/1 "2007-05-19T05:19:51Z")

</div>

Each page is getting the same 5 db results listed twice, I cant seem  
to figure out why

this is how the page look  
page 1:  
post 1  
post 2  
post 3  
post 1  
post 2  
post 3

page 2:  
post 4  
post 5  
post 6  
post 4  
post 5  
post 6

## template

\<%= render\_collection\_of\_partials “upcoming”, @albums\_pages %\>

## view (sorry its big)

\<% @upcoming.each do |i| %\>

\< %= image\_tag url\_for\_file\_column(i, "cover"), :id =\> 'cover' %\>  

## \<% @title = i.artist + " - " + i.album %\>\<%= link\_to @title, albums\_url(:permalink =\> i.permalink) %\>
[\<%= i.genre %\>] / released: \<%= i.date %\>\<%= i.info %\>  
 Hype ( +45 ) or Drop ( -7 )   
  
  
\<% end %\>
## Controller

def upcoming

@total = Albums.count

@sorter = SortingHelper::Sorter.new self, %w(artist album date),  
@params[‘sort’], @params[‘order’], ‘date’, ‘ASC’  
@albums\_pages = Paginator.new self, Albums.count, 5, @params[‘page’]  
@upcoming = Albums.find\_all nil, @sorter.to\_sql,  
@albums\_pages.current.to\_sql

render :layout =\> ‘albums\_upcoming’

end