Re: selecting records on a random basis with mysql function rand possible?
| From: | Chris | Date: | Tue, 07 May 2002 12:54:14 +0000 |
| Subject: | Re: selecting records on a random basis with mysql function rand possible? | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-19008@lists.php.net to get a copy of this message | ||
Why not just get a random number in PHP and do a select statement like that? IE
SELECT ID, city FROM data.cities WHERE country = 'CA' and ID = rand()
-Chris
At 02:52 PM 5/7/2002 +0200, andy wrote:
Hi there, is it possible to get mysql to return a record out of a table on a random basis? I tryed: select rand() ID, city from data.cities where country = 'CA' LIMIT 1 but does not work though. Has anybody an idea? I tryed also to read all results and do the random thing with php, but this does take forever (doing it for a couple of times) Thanx, Andy