Re: [PHP-DB] rand()

-------------- Original message from blackwater dev : --------------
> 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?

perror 2 returns "Error code   2:  No such file or directory"

Does /var/tmp exist on the server?

If you run explain on your query in both cases (with one record and with mor
e than one record) you will see that when there is more than one record it i
s probably using temporary tables and file sort, but is not when there's onl
y one record.

I have no idea of it is on the server or now...I just have access to
my little section of the server.  Is there another way to randomly
order?


On Wed, 29 Sep 2004 23:27:43 +0000, Jennifer Goodie <jgoodie@att.net> wrote:
> -------------- Original message from blackwater dev : -------------- 
>
> perror 2 returns "Error code   2:  No such file or directory"
>
> Does /var/tmp exist on the server?
>
> If you run explain on your query in both cases (with one record and with m
ore than one record) you will see that when there is more than one record it
 is probably using temporary tables and file sort, but is not when there's o
nly one record.
>