rand()
| From: | blackwater dev | Date: | Wed, 29 Sep 2004 23:06:26 +0000 |
| Subject: | rand() | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-36467@lists.php.net to get a copy of this message | ||
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!