Re: Generating percentages of numbers
| From: | Christian Reiniger | Date: | Thu, 22 Feb 2001 10:47:33 +0000 |
| Subject: | Re: Generating percentages of numbers | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-41125@lists.php.net to get a copy of this message | ||
On Thursday 22 February 2001 00:04, Simon Garner wrote:
> > I have a database of numbers:
> >
> > TOTAL HITS: 1000
> > PAGE 1: 500
> > PAGE 2: 250
> > PAGE 3: 250
> >
> > How can I query these numbers and display back a percentage number?
> > For instance with the numbers above:
> >
> > PAGE 1: 50%
> > PAGE 2: 25%
> > PAGE 3: 25%
> >
> > Or is their a process by which to store numbers for easily getting
> > this to work?
>
> SELECT (hitcount / 1000) * 100 AS percentage FROM sometable
Better (if it works):
SELECT (hitcount / MAX(hitcount)) * 100 AS percentage FROM sometable
--
Christian Reiniger
LGDC Webmaster (http://sunsite.dk/lgdc/)
I saw God --------- and she was black.