RE: [PHP-DB] Re: Random
| From: | Russ | Date: | Mon, 12 Aug 2002 05:26:47 +0000 |
| Subject: | RE: [PHP-DB] Re: Random | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-21110@lists.php.net to get a copy of this message | ||
ORDER BY RAND()
Russ
-----Original Message-----
From: David Robley [mailto:robleyd@paradise.net.nz]
Sent: Monday, August 12, 2002 1:08 PM
To: php-db@lists.php.net
Subject: [PHP-DB] Re: Random
In article <003601c241ad$225775e0$010aa8c0@jobsdb.com.ph>,
zhamrock@smtp.jobsdb.com.ph says...
> can someone help me to generate a random records from the database?
> eg,
>
> rec 1 john doe
> rec 2 jay williams
> rec 3 anie boo
>
> random results:
>
> rec 2 jay williams
> rec 1 john doe
> rec 3 anie boo
>
> .....
Check your database documentation - at least Mysql has a RANDOM
function.
--
David Robley
Temporary Kiwi!
Quod subigo farinam
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php