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