Sunday, 11 August 2013

My code is not giving me the desired results, please help me out

My code is not giving me the desired results, please help me out

<?php
$result = mysql_query("SELECT Male_0_4,
Female_0_4, Male_5_9, Female_5_9, Male_10_14,
Female_10_14, Male_15_19, Female_15_19,
Male_20_24, Female_20_24, Male_25_29,
Female_25_29, Male_30_34, Female_30_34,
Male_35_39, Female_35_39, Male_40_44,
Female_40_44, Male_45_49, Female_45_49,
Male_50_54, Female_50_54, Male_55_59,
Female_55_59, Male_60_64, Female_60_64,
Male_65_69, Female_65_69, Male_70_74,
Female_70_74, Male_75_plus, Female_75_plus,
sum(Male_0_4+Female_0_4+Male_5_9+Female_5_9+Male_10_14+Female_10_14+Male_15_19+Female_15_19+Male_20_24+Female_20_24+Male_25_29+Female_25_29+Male_30_34+Female_30_34+Male_35_39+Female_35_39+Male_40_44+Female_40_44+Male_45_49+Female_45_49+Male_50_54+Female_50_54+Male_55_59+Female_55_59+Male_60_64+Female_60_64+Male_65_69+Female_65_69+Male_70_74+Female_70_74+Male_75_plus+Female_75_plus)
FROM population") or die(mysql_error());
while($col = mysql_fetch_array($result)) {
?>
Total Population=<?php $total =
intval($col['Male_0_4']+ $col['Female_0_4'] +
$col['Male_5_9'] + $col['Female_5_9'] +
$col['Male_10_14'] + $col['Female_10_14'] +
$col['Male_15_19'] + $col['Female_15_19'] +
$col['Male_20_24'] + $col['Female_20_24'] +
$col['Male_25_29'] + $col['Female_25_29'] +
$col['Male_30_34'] + $col['Female_30_34'] +
$col['Male_35_39'] + $col['Female_35_39'] +
$col['Male_40_44'] + $col['Female_40_44'] +
$col['Male_45_49'] + $col['Female_45_49'] +
$col['Male_50_54'] + $col['Female_50_54'] +
$col['Male_55_59'] + $col['Female_55_59'] +
$col['Male_60_64'] + $col['Female_60_64'] +
$col['Male_65_69'] + $col['Female_65_69'] +
$col['Male_70_74'] + $col['Female_70_74'] +
$col['Male_75_plus'] + $col['Female_75_plus']);
echo $total;?>
The results are
Total Population= 8
Total Population=4
Total Population= 7

No comments:

Post a Comment