Percentage of vote in php within a while

Question

I need to take the votes of the candidates that are in mysql and generate the percentage of votes that each one had. How can I view the result since it is inside a while?

$sql =  mysql_query("SELECT * FROM candidatos ORDER BY nome_candidato");
while($ca = mysql_fetch_array($sql)){
$id_candidato = $ca['id_candidato'];
$nome_candidato = $ca['nome_candidato'];
$votos = $ca['votos'];
}

Answer 1

You can change your SELECT to do this automatically. See:

SELECT id_candidato, nome_candidato, votos, votos * 100 / t.s AS `total`
FROM candidatos
CROSS JOIN (SELECT SUM(votos) AS s FROM candidatos) t ORDER BY nome_candidato

See working

Then just use it:

$id_candidato = $ca['id_candidato'];
$nome_candidato = $ca['nome_candidato'];
$votos = $ca['votos'];
$total = $ca['total'];

Your code will look like this:

$sql =  mysql_query("SELECT id_candidato, nome_candidato, votos, votos * 100 / t.s AS `total`
FROM candidatos
CROSS JOIN (SELECT SUM(votos) AS s FROM candidatos) t ORDER BY nome_candidato");
while($ca = mysql_fetch_array($sql)){
   $id_candidato = $ca['id_candidato'];
   $nome_candidato = $ca['nome_candidato'];
   $votos = $ca['votos'];
   $total = $ca['total'];
}

Answer 2

You already have the amount of votes of each, now add these amounts to know the Toral and find out the percentage:

$sql =  mysql_query("SELECT * FROM candidatos ORDER BY nome_candidato");

$total = 0;
while($ca = mysql_fetch_array($sql)){
    $id_candidato = $ca['id_candidato'];
    $nome_candidato = $ca['nome_candidato'];
    $votos = $ca['votos'];
    $total += $ca['votos'];
}

When showing the results do the calculation:

$umporcento = $total / 100;

$porcentagem = $umporcento * $votos;