Ooo, I just though of another solution....
Assuming your banner_ID is numeric...
generate a random number between 1 and whatever (20?). We'll call it
'x'
SELECT ...
FROM banners
ORDER BY abs(banner_ID - #x#)
That way you'll "fold" the rows in the DB around some random
centerpoint and
get all the rows in a different order every time.
Be careful that #x# is some number between the min banner_ID and max
banner_ID or the order will never change.
+-----------------------------------------------+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
Telecommunication Systems
[EMAIL PROTECTED]
+-----------------------------------------------+
"...'If there must be trouble, let it be in my day, that my child may
have
peace'..."
- Thomas Paine, The American Crisis
-----Original Message-----
From: Double Down [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 01, 2002 1:55 PM
To: CF-Talk
Subject: Output Question
I am pulling records from a DB that display banners. I want to display
all of the banners, however I would like to rotate their display
position so the first record pulled is not always the first one
displayed. Any ideas?
DDINC
______________________________________________________________________
Get Your Own Dedicated Windows 2000 Server
PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation � $99/Month � Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
