ORDER BY RAND() Russ
-----Original Message----- From: David Robley [mailto:[EMAIL PROTECTED]] Sent: Monday, August 12, 2002 1:08 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Re: Random In article <003601c241ad$225775e0$[EMAIL PROTECTED]>, [EMAIL PROTECTED] 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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php