From: "Blake S." <[EMAIL PROTECTED]>
> 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
Assuming you have a row in your table for each page.
--
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]
