RE: [PHP] ORDER BY RAND()....

From: Chris W. Parker (cparker_at_swatgear.com)
Date: 10/29/03


Date: Wed, 29 Oct 2003 11:59:03 -0800
To: "Payne" <payne@magidesign.com>, "Gerard Samuel" <php-general@trini0.org>

Payne <mailto:payne@magidesign.com>
    on Wednesday, October 29, 2003 11:54 AM said:

>> Try ->
>> SELECT url FROM sponsors ORDER BY RAND() LIMIT 1;
>>
>>
>>
> I did that same thing.

SELECT url FROM sponsors ORDER BY column RAND() LIMIT 1;

How about that one?

Chris.

--
Don't like reformatting your Outlook replies? Now there's relief!
http://home.in.tum.de/~jain/software/outlook-quotefix/


Relevant Pages