Re: random?
| From: | John W. Holmes | Date: | Thu, 29 Jan 2004 13:59:39 +0000 |
| Subject: | Re: random? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-176198@lists.php.net to get a copy of this message | ||
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...