Re: ORDER BY RAND()....
| From: | Gerard Samuel | Date: | Wed, 29 Oct 2003 19:32:07 +0000 |
| Subject: | Re: ORDER BY RAND().... | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-168049@lists.php.net to get a copy of this message | ||
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;