Page List random sorting result not working as expected if pagination is enabled.

Permalink
Hi C5 Community,

I created an instance of a Page List class and then sorted it in random with rand() functionality of the class itself and I have enabled the pagination for the result.

Now, when I go to page 2. some of the results in page 1 are showing in page 2 or on any other pages. It seems, it is applying the random functionality every load regardless of what page you are in.

What I would like to happen is that it will just randomize the result once and it won't keep randomizing in every page of the pagination.

Hope my explaination is understandable. :) Any thoughts on this?

PS: I don't want to use an Ajax solution for now.

Cheers!
John

longki
 
JohntheFish replied on at Permalink Reply
JohntheFish
Because each page is extracted from the database with its own query, you shouldn't use random in combination with multiple pages. It fundamentally wont work.