Hi, I think you need to store this like Boyd said, only that you need to store this against each user/ visitor.
So, you need a table with user, result_id, order HTH, Jochen On Tue, Dec 2, 2008 at 1:01 PM, David Turton < [EMAIL PROTECTED]> wrote: > > 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] -~----------~----~----~----~------~----~------~--~---
