Re: random record mysql
| From: | tbo | Date: | Fri, 25 Apr 2003 21:32:30 +0000 |
| Subject: | Re: random record mysql | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-145319@lists.php.net to get a copy of this message | ||
When using the following" SELECT * FROM banners ORDER BY RAND() LIMIT 1 " I
still only receive the first row in that db table. Any ideas???
--
Tim Haskins
"Tbo" <tim@copiousdg.com> wrote in message
news:20030425004145.20649.qmail@pb1.pair.com...
> For the life of me I cannot figure out how to get a random record to be
> displayed off a record set using mysql and php. I have seen examples of
the
> rand() function but it only brings up the first record in the record set.
> Any ideas or tutorials? Please help!!!! :)
>
> --
> Tim Haskins
>
>
>
>