////////$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."
