Re: Random entries in php and mysql
| From: | Radu Manole | Date: | Mon, 26 Apr 2004 17:07:05 +0000 |
| Subject: | Re: Random entries in php and mysql | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-184680@lists.php.net to get a copy of this message | ||
or with md5 for better random number generation
select id, name, photo from table order by md5(rand()) limit 1
----- Original Message -----
From: "Curt Zirzow" <php-general@zirzow.dyndns.org>
To: <php-general@lists.php.net>
Sent: Monday, April 26, 2004 7:25 PM
Subject: Re: [PHP] Random entries in php and mysql
> * Thus wrote Phpu (phpu@go.ro):
> >
> > I have a database with these fields: id, name, photo.
> > I want a script that pick up randomly from my database the id, name and
photo.
> > How can i do that?
>
> select id,name,photo from table
> order by rand()
> limit 1
>
>
> Curt
> --
> "I used to think I was indecisive, but now I'm not so sure."
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php