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
