Random Recordset
I need a script that will return a selected record set in a random order.
It is basically for a villa holiday web site, and I want to return the villa search in a random order so advertisers are happy they get shown equally.
Hope you can help!
Comments
You don't need an extension
sorry - the previous answer was for PHP MySQL
Try NEWID() if you use MS SQL
Here is a good bit of information concerning your requirement:
http://www.sqlteam.com/item.asp?ItemID=8747
Rick
NEWID()
You must me logged in to write a comment.