How to get percentages out of a MySQL Table?

Question

$getKills = mysqli_query($connection, "SELECT * FROM Kills");
$getMurderer = mysqli_query($connection, "SELECT * FROM Kills WHERE Killer='$getUser->Username'");
$numKills = mysqli_num_rows($getKills);
$numKiller = mysqli_num_rows($getMurderer);

How would I get the percentage of how many kills the Player got out of all of them?

e.g. If there was 20 kills recorded, and the player only got 6, it would say

Player has 30% kills out of $numKills

Please provide some sample data. – Ullas Sep 23 '15 at 06:49 — Ullas, Sep 23 '15 at 06:49
You can do this using PHP coding just use these variables – Sunil Pachlangia Sep 23 '15 at 06:51 — Sunil Pachlangia, Sep 23 '15 at 06:51

score 0 · Answer 1 · answered Sep 23 '15 at 06:53

0

Try this

$getKills = mysqli_query($connection, "SELECT * FROM Kills");
$getMurderer = mysqli_query($connection, "SELECT * FROM Kills WHERE Killer='$getUser->Username'");

$getKillsCount = count($getKills);
$getMurdererCount = count($getMurderer);

if(empty($getKillsCount) || empty($getMurdererCount))
{
    echo 'One of Count is Empty';
}
else
{
    $precentage = ($getKillsCount/$getMurdererCount)*100;
    echo $precentage;
}

answered Sep 23 '15 at 06:53

Abdulla Nilam

36,589
17
64
85

Have you checked your code ? – Sunil Pachlangia Sep 23 '15 at 06:56
@Tiber use round function with it – Abdulla Nilam Sep 23 '15 at 16:35

score 0 · Answer 2 · answered Sep 23 '15 at 06:54

0

Usually, you can do it like this:

SELECT table.*, COUNT(*) / Table.total * 100

Or just use PHP and do the math:

$percentage = ($playerKills / $allKills) * 100;

answered Sep 23 '15 at 06:54

Konstantin Rachev

300
3
4

score 0 · Answer 3 · answered Sep 23 '15 at 07:15

Try This,

    SELECT 
              CONCAT(
                      ROUND(COUNT(*) /
                           (SELECT COUNT(*) FROM Kills)*100,2)
                     ,'%') 
            AS pcr_kills,
              (SELECT COUNT(*) FROM Kills) 
            AS tot_kills
    FROM 
            Kills 
    WHERE 
            Killer='$getUser->Username';

However, It is recommended to do this process at application side ! There would be worthless burden on the server if the < Kills > table is too large.

How to get percentages out of a MySQL Table?

3 Answers3