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
However, there are 19 rows in the database and only the first row ever shows
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
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]