Re: [PHP] Generating percentages of numbers

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%

Re: [PHP] Generating percentages of numbers

Better (if it works): SELECT (hitcount / MAX(hitcount)) * 100 AS percentage FROM sometable Nope unfortunately that does not work :( Firstly using MAX() will not work as that finds the largest value in the group; SUM() would be more appropriate as it finds the total for that column in the

[PHP] Generating percentages of numbers

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