Randomizing a recordset

[Anon]

Hey Everyone,

Here is my question.

After querying the database, and receiving a recordset with lets say five rows in the set, how do I pull one of the records out randomly, without using "order by rand() limit 1"?

If anyone can help, that would be appreciated.

Thanks,

Jason

[jcornett]

You could always put it into an array, then use the array_rand function to get a random entry...

http://www.php.net/manual/en/function.array-rand.php

John Cornett