Member Avatar for cancer10

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

  • 3 Contributors
  • 2 Replies
  • 82 Views
  • 2 Weeks Discussion Span
  • Latest Post Latest Post by nikkiH
Member Avatar for campkev

use this as your query
SELECT TOP 5 name FROM tblfriends
ORDER BY NEWID()

Member Avatar for nikkiH

Random:

SQL Server:
SELECT TOP 5 name FROM tblfriends
ORDER BY RAND()

MySQL:
SELECT name FROM tblfriends
ORDER BY RANDOM() LIMIT 5

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.