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

-----------------------------------------------
www.chargertek.in - Cheapest WebHosting

__________________
-----------------------------------------------
www.chargertek.in - Cheapest WebHosting

Get the max row count from your table and then generate a random number that is not to excced the max row count. Use this as a reference to using Rnd()

http://www.asp101.com/samples/viewas...dom_number.asp

-------------------------
I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.

^^Thats my signature