RE: [PHP-DB] Selecting random record from a database?
| From: | Beau Lebens | Date: | Wed, 03 Apr 2002 05:50:57 +0000 |
| Subject: | RE: [PHP-DB] Selecting random record from a database? | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-18152@lists.php.net to get a copy of this message | ||
SELECT * FROM quotes ORDER BY RAND() LIMIT 1
something like that, take a quick look in the MySQL (or other) docs for the
RAND() function.
HTH
Beau
// -----Original Message-----
// From: Dan Swensen [mailto:dswensen@merid.org]
// Sent: Wednesday, 3 April 2002 1:45 PM
// To: php-db@lists.php.net
// Subject: [PHP-DB] Selecting random record from a database?
//
//
// Hi all,
//
// Does anyone know a quick and easy way to select a random
// record from a
// database? I'm looking to put together a simple random quote
// generator, a la
// linux's "fortune."
//
// Any help would be much appreciated.
//
//
// --
// PHP Database Mailing List (http://www.php.net/)
// To unsubscribe, visit: http://www.php.net/unsub.php
//