RE: [PHP] random?
| From: | Chris | Date: | Thu, 29 Jan 2004 13:58:02 +0000 |
| Subject: | RE: [PHP] random? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-176202@lists.php.net to get a copy of this message | ||
Yup, I had that same thought AFTER I sent the post :)
Sorry gang.
-----Original Message-----
From: John W. Holmes [mailto:holmes072000@charter.net]
Sent: Thursday, January 29, 2004 9:00 AM
To: Chris; Php-General@Lists. Php. Net
Subject: Re: [PHP] random?
From: "Chris" <chris@glyndower.com>
> ////////$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...