SELECT RANDOM name FROM table or
SELECT name FROM table ORDER BY RANDOM LIMIT 1 not tested, used at your own free will. -- me ----- Original Message ----- From: "mm fernandez" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, July 14, 2002 11:37 PM Subject: [PHP] retrieving random data from mysql database hi, can you teach me how to retrieve random data from my database? like for example...i have a list of names on my database and i'd like to retrieve only one name at a time..randomly. how do i go about this? hope someone can help...thanx. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
