Clearly I'm not using anything yet cause I haven't started ;) I will be using the order by functionality as described by boyd or sid as a first option. Cheers Dave T
-----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Tim Oliver Sent: Tuesday, 2 December 2008 2:30 p.m. To: [email protected] Subject: [phpug] Re: randomised resultset and pagination best practice? David Turton wrote: > Sounds like an option, but I want each new result set to be random, not just > starting from a different point. I can't off the top of my head see how that > would do it. How are you randomizing the result set? If you're using mysql's rand() function, you could set a seed. eg, select * from table order by rand(userid) order by rand() isn't particularly efficient though. -- Tim Oliver Software Engineer 160 Cashel Street (Level 2) PO Box 22 128 Christchurch New Zealand P +64 3 377 0007 F +64 3 377 6582 E [EMAIL PROTECTED] www.e2media.co.nz 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] -~----------~----~----~----~------~----~------~--~---
