What DB are you using? If you are using MS SQL Server you can create a new column in your query and give it the value of a random number and then sort by that column, then just take the top record as the winner.
SELECT NEWID() AS Test FROM MyTable ORDER BY Test Just Query Your DB as normal and then add the NEWID() AS Whatever column name you want and then order by it HTH -- Alan Rother Macromedia Certified Advanced ColdFusion MX 7 Developer ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236461 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
