Re: Random PostreSQL
| From: | joe at jWebMedia dot com | Date: | Tue, 01 Aug 2000 21:19:57 +0000 |
| Subject: | Re: Random PostreSQL | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-1685@lists.php.net to get a copy of this message | ||
Miles Thompson wrote:
> My first question is "why"?
We want to display 6 random products on the home page. Maybe there is a better
way to do this than selecting randomly from the database. If I set an array of
column names in PHP and randomly select one of those to order by I may get a
random effect. There should be hundreds of products in the database at any
given moment, so ordering differently and limiting it to 6 results should at
least appear slightly random, right? Thanks,
Joe