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
