2 Mysql RAND() SELECTS in the same script

[nic0las]

Hi,
I made a php script that selects a random line in a mysql database using this query : "SELECT FROM sites ORDER BY RAND( UNIX_TIMESTAMP() ) LIMIT 1".
It works well and selects a random line. No problem whit this one.
But as I try to select another entry in another table, in the same page, using this : "SELECT FROM partners ORDER BY RAND( UNIX_TIMESTAMP() ) LIMIT 1", it always selects the same entry!
As if the first random number (the one from the first query) wasn't cleared or something.
Any idea ?
Thanks!

[mikesgt2]

Remove the [FONT=courier new]UNIX_TIMESTAMP()[/FONT] bit from the [FONT=courier new]RAND()[/FONT] call.

Build a script that sends 5 rand queries. If you put in the unix_timestamp then all the numbers are the same.