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" <[EMAIL PROTECTED]> schrieb im Newsbeitrag
> 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
> >it for a couple of times)
> >
> >Thanx, Andy

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to