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