anyone ever have trouble using RAND() or RAND(NOW()) with dreamhosts MySQL servers? I should be able to get a random record set from MYSQL with “SELECT * FROM whatevertable ORDER BY RAND()”.
but it doesn’t seem to work. even used RAND(NOW()) and while it gave me a different record then without NOw() it stops being random.
anyone have any ideas?