Re: [PHP] Making MYSQL's RAND() more random

2005-10-10 Thread Richard Lynch
On Mon, October 3, 2005 2:39 pm, Graham Anderson wrote: > what would be the best way to make MYSQL's RAND() more random ? > > my random result set always seems pretty predictable. The first > record > in the result set always seems to be the same 4 tracks :( > Would adding some kind of random seed

Re: [PHP] Making MYSQL's RAND() more random

2005-10-03 Thread Greg Donald
On 10/3/05, Graham Anderson <[EMAIL PROTECTED]> wrote: > what would be the best way to make MYSQL's RAND() more random ? http://dev.mysql.com/doc/mysql/en/mathematical-functions.html: RAND() is not meant to be a perfect random generator, but instead a fast way to generate ad hoc random numbers t

[PHP] Making MYSQL's RAND() more random

2005-10-03 Thread Graham Anderson
what would be the best way to make MYSQL's RAND() more random ? my random result set always seems pretty predictable. The first record in the result set always seems to be the same 4 tracks :( Would adding some kind of random seed like RAND($randomNumberGenerator) work ? If so, how do you imp