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 [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > 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 > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php