PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]
Subject: [PHP-DEV] Random Row From Database
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
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
(you'd already have expected this, i guess...)
I still have hardly no feedback on proposal 3b of random change:
http://www.a-eskwadraat.nl/~jeroen/rand/
The main issue - inconsistent and duplicate functions for random, no way
to explicitly and portably get reproducable results - isn't solved by