problem with pagination

For one your creating your pagination links before you get you data from the database to display.

Your create links show be last just before your load your view.

I did the same, but did not change.