Re: ORDER BY RAND()....
| From: | Payne | Date: | Wed, 29 Oct 2003 19:53:51 +0000 |
| Subject: | Re: ORDER BY RAND().... | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-168053@lists.php.net to get a copy of this message | ||
Gerard Samuel wrote:
On Wednesday 29 October 2003 02:24 pm, Payne wrote:Hi, I have been working on a simple PHP script that called to a mysql database, where I do the following.... SELECT url FROM sponsors ORDER BY RAND();Try -> SELECT url FROM sponsors ORDER BY RAND() LIMIT 1; I did that same thing.