This recent thread from the mysql list explains a lot about the
problem.
http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:mss:15034
hth,
Doug
On Sat, 1 Mar 2003 12:24:57 +0100, Frank Keessen wrote:
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
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php