Depending how big your result sets are you could store them as an array and pass them from page to page. Not very elegant I know but you could stick it into a session variable.
Otherwise you could risk disk writes and serialise the array into a flat file and store it temporarily. If your data set does not need to be entirely random then Boyds solution could be adapted as Sid has mentioned already. 2008/12/2 David Turton <[EMAIL PROTECTED]>: > > 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. > Dave T > > > -----Original Message----- > From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Boyd > Sent: Tuesday, 2 December 2008 12:36 p.m. > To: NZ PHP Users Group > Subject: [phpug] Re: randomised resultset and pagination best practice? > > > how about creating a random_id col for the db, every time you add a > record add a random number rand(0,1000000); then sort on that, and > index that col. > > On Dec 2, 12:01 pm, David Turton > <[EMAIL PROTECTED]> wrote: >> Hi, >> I have a result set of 200+ records, paginated in blocks of 10 e.g. 20+ pages >> I need to randomize the result set (no problem), but I can't find which is >> the best way of storing the result in its randomized order. >> I'm looking for best practice that uses the least memory/processing, etc. >> Suggestions? >> Thanks >> Dave T >> >> ________________________________ >> 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 >> ##################################################################################### > > > 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 > ##################################################################################### > > > > -- Simon Holywell http://www.simonholywell.com --~--~---------~--~----~------------~-------~--~----~ NZ PHP Users Group: http://groups.google.com/group/nzphpug To post, send email to [email protected] To unsubscribe, send email to [EMAIL PROTECTED] -~----------~----~----~----~------~----~------~--~---
