Random not working?
| From: | Frank Keessen | Date: | Sat, 01 Mar 2003 11:24:57 +0000 |
| Subject: | Random not working? | ||
| Groups: | php.db php.general | ||
| Request: | Send a blank email to php-db+get-26025@lists.php.net to get a copy of this message | ||
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