Directorate General of Family Planning, MIS Unit
Upazila Wise Population Data
@$m=$_POST['H_Mon'];
@$y=$_POST['H_Year'];
$Date="$y-12-28";
$result6 = mysql_query("Select method_taken.Thana_Code,a.Thana_name,b.Total_EC,c.Dist_name,
sum(Oralpill)+sum(Condom)+sum(Injectable)+sum(IUD)+sum(Norplant)+
sum(P_Male)+sum(P_Female)+sum(N_Taken)+sum(Pragnant) Total_elco
From method_taken,
(Select Thana_Code,Thana_name,Dist_code From thana)a,
(Select Thana_Code,Total_EC From population Where population.Month_Id='$Date')b,
(Select Dist_Code,Dist_name From district)c
Where method_taken.Month_Id='$Date' And method_taken.Thana_Code=b.Thana_Code
And b.Thana_Code=a.Thana_Code And a.Dist_code=c.Dist_code
Group by method_taken.Thana_Code ");
$num=mysql_num_rows($result6);
?>
Reporting Year: |
echo $y; ?> |
District |
Upazila/Thana |
Elco Population |
Elco Methodwise |
Differance |
$i=0;
while ($i<$num){
$num_id=1;
$Thana_name =mysql_result($result6,$i,"a.Thana_name");
$District_name =mysql_result($result6,$i,"c.Dist_name");
$elco_population=mysql_result($result6,$i,"b.Total_EC");
$elco_methodwise=mysql_result($result6,$i,"Total_elco");
$differ=$elco_population-$elco_methodwise;
?>
echo $District_name;?> |
echo $Thana_name;?> |
echo $elco_population;?> |
echo $elco_methodwise;?> |
echo $differ;?> |
++$i;
}
?>