That would also work a treat, I believe, if I could be bothered creating a series of views in different orders. Perhaps if the other didn't go so smoothly, I would've gone down this road. Cheers Dave T
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Rory Casey Sent: Tuesday, 2 December 2008 2:40 p.m. To: [email protected] Subject: [phpug] Re: randomised resultset and pagination best practice? 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 ________________________________ Warning: This email contains information which is CONFIDENTIAL and may also be LEGALLY PRIVILEGED. If you are not the intended recipient you must not peruse, use, disseminate, distribute or copy this email or attachments. If you have received this in error, please notify us immediately by return email and delete this email. Thank you. ##################################################################################### This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal ##################################################################################### --~--~---------~--~----~------------~-------~--~----~ NZ PHP Users Group: http://groups.google.com/group/nzphpug To post, send email to [email protected] To unsubscribe, send email to [EMAIL PROTECTED] -~----------~----~----~----~------~----~------~--~---
