Re: selecting records on a random basis with mysql function rand possible?
| From: | andy | Date: | Tue, 07 May 2002 13:14:14 +0000 |
| Subject: | Re: selecting records on a random basis with mysql function rand possible? | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-19010@lists.php.net to get a copy of this message | ||
but how can I be sure that this id does exist?
sure, I could count all records and than do a rand(0,$value); but there
might be a better way in mysql directly.
"Chris" <ragabash@adelphia.net> schrieb im Newsbeitrag
news:5.1.0.14.0.20020507085145.00b10dc0@mail.pit.adelphia.net...
> 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
>