note 8055 added to rand
| From: | hartmut at six dot de | Date: | Fri, 25 Aug 2000 10:43:05 +0000 |
| Subject: | note 8055 added to rand | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-3234@lists.php.net to get a copy of this message | ||
don't use this for getting database
records by random, MySQL has a RANDOM()
function of its own that does a better job
just use
SELECT ... FROM ... WHERE ... ORDER BY RAND() LIMIT 1
to get a random row from any query
http://www.php.net/manual/function.rand.php