Thanks guys for the info; I will speak to my ISP!
Have a nice weekend!
Regards,
Frank
----- Original Message -----
From: "Rich Gray" <rich@f1central.net>
To: "Frank Keessen" <fkeessen@planet.nl>; <php-general@lists.php.net>;
<php-db@lists.php.net>
Sent: Sunday, March 02, 2003 2:36 AM
Subject: 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
>
>
> 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
ID
> column then a workaround would be to use rand() in PHP to generate a
random
> ID then use that with a 'where id = '.$id in your query...
>
> HTH
> Rich
>
>
> --
> 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
