random?

From: Date: Thu, 29 Jan 2004 13:34:22 +0000
Subject: random?
Groups: php.general 
Request: Send a blank email to php-general+get-176194@lists.php.net to get a copy of this message
////////$sql = "SELECT * FROM agentdb WHERE ((OfficeID <> 214) and (agentdb.agent_id<> 1115421) and (agentdb.agent_id > 100) and agentdb.agent_id <> 333)) ORDER BY RAND() LIMIT 1"; The above code should generate a random agent upon refresh. It does however seem to favor one agent more than the others. The agent id it used to favor was "333" i added the "(agentdb.agent_id <> 333)" to disallow that agent from being displayed. But now it wants to favor an agent whose id number is "1167553" The function can be seen here: http://c21alliancerealty.com/area.php it is the random "Featured Agent" on the left hand side of the page. Does anyone have any suggestions as to why this is occuring, please? ############################## Glyndower Web Designs http://www.glyndower.com 352.684.2290 ############################## "What are we holding on to Sam?" "That theres some good in this world, Mr. Frodo, and it's worth fighting for."

« previous php.general (#176194) next »