Re: how to display photos of the day?
| From: | Zoltán Németh | Date: | Tue, 29 Jan 2008 10:53:16 +0000 |
| Subject: | Re: how to display photos of the day? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-268240@lists.php.net to get a copy of this message | ||
2008. 01. 29, kedd keltezéssel 18.33-kor jeffry s ezt írta:
> sorry if this question sound stupid.
> i need a good, simple and efficient function to display lets say photo of
> the day.
>
> i have a mysql table contain data about 1000 rows. i want to display any of
> the photos randomly
> and it is fixed for one day.
>
> anyone know how to write the function that return a fixed table id for the
> day?
a good article on the subject:
http://www.titov.net/2005/09/21/do-not-use-order-by-rand-or-how-to-get-random-rows-from-table/
greets
Zoltán Németh