Pagination on Random Result Set ?

[eluser]chrisco23[/eluser]
I started down the path of session variables and temporary tables when suddenly I thought of a very simple solution that works fine for my needs.

Our site just needs to give equal exposure to results so we need them to be randomized generally but not every single query.

So I just generated a random-number seed and put that in a session variable. Then I do my query with rand(seed) instead of just rand(). It turns out in my case that it's actually desirable to have the same random order throughout a session.


Chris