From: "Chris" <[EMAIL PROTECTED]>

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

> It does however seem to favor one agent more than the others.

> Does anyone have any suggestions as to why this is occuring, please?

I'd ask on a MySQL list/forum. This isn't going to be a PHP issue. Maybe
MySQL's RAND() function isn't very random.

---John Holmes...

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to