Thanks guys for the info; I will speak to my ISP!
Have a nice weekend!
----- Original Message -----
From: "Rich Gray" <[EMAIL PROTECTED]>
To: "Frank Keessen" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>;
Sent: Sunday, March 02, 2003 2:36 AM
Subject: [PHP-DB] RE: [PHP] Random not working?
> > 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
> 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
> column then a workaround would be to use rand() in PHP to generate a
> ID then use that with a 'where id = '.$id in your query...
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php