result of a column by percent

webgod

How do I display the result of a column by percent?

ie.. I have a column called gender. I want to get this output:
Male = 20%
Female = 80%

barand

$sql = "SELECT gender, COUNT(*) as gencount FROM mytable GROUP BY gender";
$array = array();
$query = mysql_query($sql);
while (list($gender, $count)=mysql_fetch_row($query)) {
$array[$gender] = $count;
}

$total = array_sum($array);

Now you know how many of each and the total to calculate the %'s

webgod

whew... ok.. I really am lost looking at that code. I don't get how to output it... I think I understand the total. It's the total of each (Male, Female) that I don't see.. a little more help (please)

barand

If you have x males and y females then array will contain

male => x
female => y

To check, use this code

echo '<pre>'; print_r($array); echo '</pre>';

So,

echo "<br>Male percent : " . $array['male'] 100 / $total;
echo "<br>Female percent : " . $array['female'] 100 / $total;

If gender is held as 'M' or 'F' then use these in the above code instead of 'male', 'female'.

hth

webgod

Hey That did the trick... however do you know how to limit the decimal places to two or none? This is a bit rough on the eyes:

Male percent : 83.333333333333
Female percent : 16.666666666667

webgod

Hey That did the trick... however do you know how to limit the decimal places to two or none? This is a bit rough on the eyes:

Male percent : 83.333333333333
Female percent : 16.666666666667

Weedpacket

Something like [man]number_format[/man] or [man]printf[/man] (or just [man]floor[/man] or [man]round[/man]) would do. Say,

round($array['female']*100/$total)