Pagination with sorting

Pagination with sorting

El Forum
Guest

02-27-2009, 11:21 AM

[eluser]spyro[/eluser]
I have read a few other posts on this subject but have not seen what I was looking for. I am using the CI pagination class and decided to sort my on a certain value in desc order. The problem is that when I request each section of data from the database I am specifying an offset and then sorting only those results.

Example ( I am sorting on total reviews )
Reviews 1
Reviews 3
Reviews 20

on the second page I will have
Reviews 2
Reviews 5
Reviews 16

When what I really need is for these to be in order across all pages. I know this have been done a thousand times but this is my first. Please advise.

Messages In This Thread

Pagination with sorting - by El Forum - 02-27-2009, 11:21 AM

Pagination with sorting - by El Forum - 02-27-2009, 11:39 AM

Pagination with sorting - by El Forum - 02-27-2009, 12:26 PM

Pagination with sorting - by El Forum - 02-27-2009, 12:48 PM

Pagination with sorting - by El Forum - 02-27-2009, 01:39 PM

Pagination with sorting - by El Forum - 02-27-2009, 01:54 PM

Pagination with sorting - by El Forum - 02-27-2009, 02:10 PM

Pagination with sorting - by El Forum - 02-27-2009, 02:19 PM

Pagination with sorting - by El Forum - 02-27-2009, 02:36 PM

Pagination with sorting - by El Forum - 02-27-2009, 02:47 PM

Pagination with sorting - by El Forum - 02-27-2009, 02:52 PM

Pagination with sorting - by El Forum - 02-27-2009, 02:58 PM

Pagination with sorting - by El Forum - 02-27-2009, 03:08 PM

Pagination with sorting - by El Forum - 02-27-2009, 03:16 PM

Pagination with sorting - by El Forum - 02-27-2009, 03:27 PM

Pagination with sorting - by El Forum - 02-27-2009, 03:28 PM

Pagination with sorting - by El Forum - 02-27-2009, 03:34 PM

Pagination with sorting - by El Forum - 02-27-2009, 03:40 PM

Pagination with sorting - by El Forum - 02-27-2009, 03:42 PM

Pagination with sorting - by El Forum - 02-27-2009, 03:52 PM

Pagination with sorting - by El Forum - 02-27-2009, 03:56 PM

Pagination with sorting - by El Forum - 02-27-2009, 03:58 PM

Pagination with sorting - by El Forum - 02-27-2009, 04:09 PM

Pagination with sorting - by El Forum - 02-27-2009, 04:43 PM

Pagination with sorting - by El Forum - 02-27-2009, 07:10 PM

Pagination with sorting - by El Forum - 02-27-2009, 07:29 PM

Pagination with sorting - by El Forum - 02-27-2009, 07:52 PM

Pagination with sorting - by El Forum - 02-27-2009, 08:00 PM

Pagination with sorting - by El Forum - 02-27-2009, 10:20 PM

Pagination with sorting - by El Forum - 02-28-2009, 09:38 AM