note 23003 added to function.rand
| From: | admin at theangryangel dot co dot uk | Date: | Sat, 06 Jul 2002 12:50:54 +0000 |
| Subject: | note 23003 added to function.rand | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-32677@lists.php.net to get a copy of this message | ||
jeff@eksx.no-ip.com ->
In MySQL 3.23 or greater, the following query selects a random row :
SELECT * FROM tablename ORDER BY RAND() LIMIT 1
this does work
--
http://www.php.net/manual/en/function.rand.php
http://master.php.net/manage/user-notes.php?action=edit+23003
http://master.php.net/manage/user-notes.php?action=delete+23003
http://master.php.net/manage/user-notes.php?action=reject+23003