php sql percentage of rows

Posted August 31, 2014 1.8k views

Hello i have problem, i want to my php script calculate percent of ex.

row 1 have ‘dmg’ value '62’
row 2 have 'dmg’ value '38’

now, script need sto calculate this etc:

row 1 is:
62% of total 'dmg’

and row 2 is:

the percent need to be max. 100% ex. 'dmg’ of row 1 can be 6200 and 'dmg’ of row 2 can be 3800 but percent need to be 100% max…

any help? i tryed scripts but no one helps .. thanks!! try.

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Submit an Answer
1 answer

Hi! Your question is a little unclear. In php you can calculate a percentage like you normally would. For instance, 3000 is 48.39% of 6200:

# php -a
php > $n = 3000;
php > echo (($n / 6200) * 100)."\n";

Maybe if you could be more specific about the problem you’re facing, we can help you better.