RE: [PHP] Random not working?

> Hi All, > > I'm trying to get a random record each time this script runs; > Only it's giving me everytime the first record back.. No random at all.. > > // generate and execute query > $query = "SELECT stedenid, naamstad, stadomschrijvk FROM steden > ORDER BY RAND() LIMIT 1"; > $result = mysql_query($query) or die ("Error in query: $query. " > . mysql_error()); > $row = mysql_fetch_object($result); > echo $row->naamstad; > > > Version info; > > PHP 4.3.1 > Mysql 3.23.54 > > When i'm trying to excute the SELECT statement in phpmyadmin; i'm > only getting the first record back and when i'm taking off the > LIMIT 1 it will display all the records in ascending order so > also not in random.. > > > Regards, > > Frank Frank This really belongs on the MySQL list but there was a known issue with RAND() on 3.23.54 - can you upgrade? If your table has an auto_increment ID column then a workaround would be to use rand() in PHP to generate a random ID then use that with a 'where id = '.$id in your query... HTH Rich