Re: random data from mysql db
| From: | George Nicolae | Date: | Mon, 05 Aug 2002 08:41:43 +0000 |
| Subject: | Re: random data from mysql db | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-111188@lists.php.net to get a copy of this message | ||
SELECT * FROM tablename ORDER BY RAND() LIMIT 1
--
Best regards,
George Nicolae
IT Manager
___________________
PaginiWeb.com - Professional Web Design
www.PaginiWeb.com
"Tux" <tuxen@gimped.net> wrote in message
news:1028586495.12082.47.camel@tuxen.gimped.net...
>
> hey guys,
>
> what im trying to do is display a random entry from a mysql db, is there
> a function for this? or do i just have to generate a random number and
> go from there?
>
> jo
>
>
>