How do I select randomly from database [Archive]

Click to See Complete Forum and Search --> : How do I select randomly from database

damon2003

08-22-2003, 07:07 AM

Hi,
I have an asp page that access an access database. I want to update my page with random records from the database every day,how can this be done,
thanks a lot

A1ien51

08-22-2003, 11:53 AM

Just ideas:

have a random number generator and just move to that record in the database.

If you want it to not to repeat, you would need to keep a log on that.