order by rand problem

[listenmirndt]

Hello, has anyone seen an occurance where order by rand does not randomize very well? like, mabey once in 15 page refreshes?

Could this be a server misconfiguration? Or?..

Thanks

[drawmack]

it's a random order based on the timestamp or the request. I can see it degenerating sometimes. mt_rand is better but that's a php function so you'd have to pull the id's into an array then mt_rand that array and use this to get the full data in a random order.