At 11:47 22-2-01 +0100, Christian Reiniger wrote:
>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
Should be sum then i think :)
>--
>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]
--
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]
