Re: Random not working?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux