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
