Rand()
| From: | blackwater dev | Date: | Thu, 07 Oct 2004 13:28:23 +0000 |
| Subject: | Rand() | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-36669@lists.php.net to get a copy of this message | ||
I have the following query:
Select id, fname, lname from clients where featured=1 order by RAND()
At any time, there should only be three clients where featured =1.
Problem is I have run this query several times yet it always returns
them in the same order. Not sure it makes a difference but the
primary key is on the id column. What am I doing wrong?
Thanks!