What is the best way to select random records? Say I have a SELECT statement that returns 50 records. I then want to select 25 out of that set at random. What is the best way to do that?
I would dump the records into an array and create random numbers to determine what records should be displayed.<BR><BR>Just my 2cp
I think there are a couple of faqs that discuss this.