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:[EMAIL PROTECTED]]
// Sent: Wednesday, 3 April 2002 1:45 PM
// To: [EMAIL PROTECTED]
// 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
//
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php