Yeah, I had tried that earlier but it doesn't work. It does generate a new value for temp each time but they are still in the same order as the first one always has a lower temp value.... On Thu, 7 Oct 2004 06:40:23 -0700, Ed Lazor <ed.lazor@xxxxxxxxxxx> wrote: > > > select id, fname, lname, RAND() as temp from clients where featured=1 order > by temp > > > -----Original 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! > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
