Retrieving Records

[berbbrown]

Hi All

I have a set of records which I return based upon a criteria. Imagine returing 20 records.

How can I randomise the list of records? Rather than display them based upon Key/Index I would like to show the list in a random order each time?

Any ideas?

TA

BB

[olaf]

i found this on another board:

SELECT * FROM table_name ORDER BY RAND()