if you wants each new result set to be random, then you can not "store" it. since once result set stored , order is fixed.
why do you need to store a random result set? is randomize result set take a lot of time? regards, On Dec 2, 12:48 pm, David Turton <[EMAIL PROTECTED]> 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. > 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 > ##################################################################################### --~--~---------~--~----~------------~-------~--~----~ NZ PHP Users Group: http://groups.google.com/group/nzphpug To post, send email to [email protected] To unsubscribe, send email to [EMAIL PROTECTED] -~----------~----~----~----~------~----~------~--~---
