Random Row From Database
| From: | HEW Staff | Date: | Sun, 11 Nov 2001 04:18:58 +0000 |
| Subject: | Random Row From Database | ||
| Groups: | php.db php.dev php.general | ||
| Request: | Send a blank email to php-db+get-14226@lists.php.net to get a copy of this message | ||
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