Yup, I had that same thought AFTER I sent the post :) Sorry gang.
-----Original Message----- From: John W. Holmes [mailto:[EMAIL PROTECTED] Sent: Thursday, January 29, 2004 9:00 AM To: Chris; [EMAIL PROTECTED] Php. Net Subject: Re: [PHP] random? 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
