Hello, I have the following query: select * from clients order by RAND() THe query runs fine on my local server but when I run it on my hosts server, it works ok if there is only one record in the db but then there is more than one...I get this error: #1 - Can't create/write to file '/var/tmp/#sqlbe_1d99_0.MYI' (Errcode: 2) What's going on? Thanks! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
