Re: Random entries in php and mysql
| From: | Curt Zirzow | Date: | Mon, 26 Apr 2004 16:25:18 +0000 |
| Subject: | Re: Random entries in php and mysql | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-184673@lists.php.net to get a copy of this message | ||
* 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."