random?
| From: | Chris | 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."