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 > ##################################################################################### --~--~---------~--~----~------------~-------~--~----~ NZ PHP Users Group: http://groups.google.com/group/nzphpug To post, send email to [email protected] To unsubscribe, send email to [EMAIL PROTECTED] -~----------~----~----~----~------~----~------~--~---
