Another option (although kind of the same as all the other ideas) is to create a view in your database that only contains the randomly ordered result-set (in the order you want). Pagination will just select from the view. When you need a new random order, drop the view and create a new one.
Not sure of the performance implications though --~--~---------~--~----~------------~-------~--~----~ NZ PHP Users Group: http://groups.google.com/group/nzphpug To post, send email to [email protected] To unsubscribe, send email to [EMAIL PROTECTED] -~----------~----~----~----~------~----~------~--~---
