ASP - Random values from database

Hello,

I have a question:

Suppose I have a table named as tblfriends and there are 3 columns with several row. Column names are: name, email, phone

I want to pick 5 names randomly from the table each time my asp page refreshes.


How can this be coded in classic asp?



Thanx for your help

http://www.stardeveloper.com/articles/display.html?article=2000082901&page=1