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