I mean "store" so when I click on page 5 or next page etc, I get the appropriate subset of the result set e.g. 11-20. If I re-query using random on each page, the order is changed (of course). I want to create a random list on first page, store it for reference on other pages. Another revisit to first page (assuming result set doesn't already exist) creates a new random result set. Make sense? Thanks for any pointers. Dave T
-----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of ctx2002 Sent: Tuesday, 2 December 2008 12:55 p.m. To: NZ PHP Users Group Subject: [phpug] Re: randomised resultset and pagination best practice? 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 > ##################################################################################### 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] -~----------~----~----~----~------~----~------~--~---
