Hi, I'm trying to pull a random row from my database and display the contents.
I know that the code: SELECT * FROM TABLENAME WHERE RAND() LIMIT 1 should work. However, there are 19 rows in the database and only the first row ever shows up. Is there a way to do this to ensure uniqueness? The code I am using at the moment also filters so that rows are pulled from the database given certain other criteria such as: SELECT * FROM TABLENAME WHERE PayerID=$id AND RAND() LIMIT 1 All of the rows in the database contain the same PayerID and this column is not the Primary Key. Any help much appreciated. Jonathan S Hardiman President/CEO Hardiman Enterprises Worldwide -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
