RE: [PHP] ORDER BY RAND()....
| From: | Chris W. Parker | Date: | Wed, 29 Oct 2003 19:59:03 +0000 |
| Subject: | RE: [PHP] ORDER BY RAND().... | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-168054@lists.php.net to get a copy of this message | ||
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/