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.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
