//Date
@$m=$_POST['H_Mon'];
@$m1=$_POST['H_Mon1'];
@$y=$_POST['H_Year'];
@$y1=$_POST['H_Year1'];
$Date="$y-$m-01";
$Date1="$y1-$m1-31";
//Month name
$sql=mysql_query("select M_name from month where M_id='$m'");
$rowM=mysql_fetch_array($sql);
$M_Name=$rowM['M_name'];
$sql1=mysql_query("select M_name from month where M_id='$m1'");
$rowM1=mysql_fetch_array($sql1);
$M_Name1=$rowM1['M_name'];
$Dist_Name = mysql_query("select district.Dist_Name from district where Dist_Code='$Dist_Id'");
$rowD=mysql_fetch_array($Dist_Name);
$D_Name=$rowD['Dist_Name'];
$Thana_Name = mysql_query("select Thana_name from thana where Thana_code='$Thana_code'");
$rowT=mysql_fetch_array($Thana_Name);
$T_Name=$rowT['Thana_name'];
//Total Pregnant Mother
$pmum_num=mysql_query("SELECT count( couple_id ) couplenum FROM pregnant_mum
WHERE thana_id = '$Thana_code' AND month_Id BETWEEN '$Date' AND '$Date1' AND birth_date='0000-00-00'");
$rowD1=mysql_fetch_array($pmum_num);
$totalpregnant_num=$rowD1['couplenum'];
//ANC1st visit
$resultcoupleid =mysql_query("select count(couple_id) coupleid from pregnant_mum
WHERE `lmp_date`+INTERVAL 120 DAY Between '$Date' and '$Date1' and thana_id='$Thana_code' ");
$row=mysql_fetch_array($resultcoupleid);
$anc1=$row['coupleid'];
$resultanc1st =mysql_query("select count(anc1st_visit) anc1st from pregnant_mum
WHERE `lmp_date`+INTERVAL 120 DAY Between '$Date' and '$Date1' and thana_id='$Thana_code' and anc1st_visit In('Actual','Deley') ");
$row1=mysql_fetch_array($resultanc1st);
$anc1y=$row1['anc1st'];
$anc1n=$anc1-$anc1y;
//ANC2nd visit
$resultcoupleid =mysql_query("select count(couple_id) coupleid from pregnant_mum
WHERE `lmp_date`+INTERVAL 180 DAY Between '$Date' and '$Date1' and thana_id='$Thana_code' ");
$row=mysql_fetch_array($resultcoupleid);
$anc2=$row['coupleid'];
$resultanc2nd =mysql_query("select count(anc2nd_visit) anc2nd from pregnant_mum
WHERE `lmp_date`+INTERVAL 180 DAY Between '$Date' and '$Date1' and thana_id='$Thana_code' and anc2nd_visit In('Actual','Deley') ");
$row2=mysql_fetch_array($resultanc2nd);
$anc2y=$row2['anc2nd'];
$anc2n=$anc2-$anc2y;
//ANC3rd visit
$resultcoupleid =mysql_query("select count(couple_id) coupleid from pregnant_mum
WHERE `lmp_date`+INTERVAL 240 DAY Between '$Date' and '$Date1' and thana_id='$Thana_code' ");
$row=mysql_fetch_array($resultcoupleid);
$anc3=$row['coupleid'];
$resultanc3rd =mysql_query("select count(anc3rd_visit) anc3rd from pregnant_mum
WHERE `lmp_date`+INTERVAL 240 DAY Between '$Date' and '$Date1' and thana_id='$Thana_code' and anc3rd_visit In('Actual','Deley') ");
$row3=mysql_fetch_array($resultanc3rd);
$anc3y=$row3['anc3rd'];
$anc3n=$anc3-$anc3y;
//ANC4th visit
$resultcoupleid =mysql_query("select count(couple_id) coupleid from pregnant_mum
WHERE `lmp_date`+INTERVAL 270 DAY Between '$Date' and '$Date1' and thana_id='$Thana_code' ");
$row=mysql_fetch_array($resultcoupleid);
$anc4=$row['coupleid'];
$resultanc4th =mysql_query("select count(anc4th_visit) anc4th from pregnant_mum
WHERE `lmp_date`+INTERVAL 270 DAY Between '$Date' and '$Date1' and thana_id='$Thana_code' and anc4th_visit In('Actual','Deley') ");
$row4=mysql_fetch_array($resultanc4th);
$anc4y=$row4['anc4th'];
$anc4n=$anc4-$anc4y;;
//Total Pregnant Mother for ANC
$pregnant_num=$anc1+$anc2+$anc3+$anc4;
//About Delivery
if (isset($y) && isset($y1)) {
$deliv_num=mysql_query("SELECT count( birth_date ) deliverynum FROM pregnant_mum
WHERE thana_id = '$Thana_code' AND birth_date BETWEEN '$Date' AND '$Date1'");
$rowD1=mysql_fetch_array($deliv_num);
$delivery_num=$rowD1['deliverynum']; }
else {
$delivery_num=0; }
//House
$house =mysql_query("select count(couple_id) coupleid from pregnant_mum
WHERE thana_id = '$Thana_code' AND birth_date BETWEEN '$Date' AND '$Date1' and delivery_status_where='House' ");
$row=mysql_fetch_array($house);
$house_delivery=$row['coupleid'];
//Hospital
$hospital =mysql_query("select count(couple_id) coupleid from pregnant_mum
WHERE thana_id = '$Thana_code' AND birth_date BETWEEN '$Date' AND '$Date1' and delivery_status_where='Hospital' ");
$row=mysql_fetch_array($hospital);
$hospital_delivery=$row['coupleid'];
//SBA
$SBA =mysql_query("select count(couple_id) coupleid from pregnant_mum
WHERE thana_id = '$Thana_code' AND birth_date BETWEEN '$Date' AND '$Date1' and delivery_status_who='SBA' ");
$row=mysql_fetch_array($SBA);
$SBA_delivery=$row['coupleid'];
//Non Trained Person
$NTP =mysql_query("select count(couple_id) coupleid from pregnant_mum
WHERE thana_id = '$Thana_code' AND birth_date BETWEEN '$Date' AND '$Date1' and delivery_status_who='Non Trained Person' ");
$row=mysql_fetch_array($NTP);
$NTP_delivery=$row['coupleid'];
//Normal
$Normal =mysql_query("select count(couple_id) coupleid from pregnant_mum
WHERE thana_id = '$Thana_code' AND birth_date BETWEEN '$Date' AND '$Date1' and delivery_status_type='Normal' ");
$row=mysql_fetch_array($Normal);
$Normal_delivery=$row['coupleid'];
//C-section
$Scissorion =mysql_query("select count(couple_id) coupleid from pregnant_mum
WHERE thana_id = '$Thana_code' AND birth_date BETWEEN '$Date' AND '$Date1' and delivery_status_type='C-section' ");
$row=mysql_fetch_array($Scissorion);
$Scissorion_delivery=$row['coupleid'];
//Live Birth
$Live =mysql_query("select count(couple_id) coupleid from pregnant_mum
WHERE thana_id = '$Thana_code' AND birth_date BETWEEN '$Date' AND '$Date1' and delivery_status_condition='Live Birth' ");
$row=mysql_fetch_array($Live);
$Live_Birth=$row['coupleid'];
//Still Birth
$Still =mysql_query("select count(couple_id) coupleid from pregnant_mum
WHERE thana_id = '$Thana_code' AND birth_date BETWEEN '$Date' AND '$Date1' and delivery_status_condition='Still Birth' ");
$row=mysql_fetch_array($Still);
$Still_Birth=$row['coupleid'];
//child_status1y
$child1y =mysql_query("select count(couple_id) coupleid from pregnant_mum
WHERE thana_id = '$Thana_code' AND birth_date BETWEEN '$Date' AND '$Date1' and child_status1='Yes' ");
$row=mysql_fetch_array($child1y);
$child_status1y=$row['coupleid'];
//child_status1n
$child1n =mysql_query("select count(couple_id) coupleid from pregnant_mum
WHERE thana_id = '$Thana_code' AND birth_date BETWEEN '$Date' AND '$Date1' and child_status1='No' ");
$row=mysql_fetch_array($child1n);
$child_status1n=$row['coupleid'];
//child_status2y
$child2y =mysql_query("select count(couple_id) coupleid from pregnant_mum
WHERE thana_id = '$Thana_code' AND birth_date BETWEEN '$Date' AND '$Date1' and child_status2='Yes' ");
$row=mysql_fetch_array($child2y);
$child_status2y=$row['coupleid'];
//child_status2n
$child2n =mysql_query("select count(couple_id) coupleid from pregnant_mum
WHERE thana_id = '$Thana_code' AND birth_date BETWEEN '$Date' AND '$Date1' and child_status2='No' ");
$row=mysql_fetch_array($child2n);
$child_status2n=$row['coupleid'];
//brest_feedingy
$child2y =mysql_query("select count(couple_id) coupleid from pregnant_mum
WHERE thana_id = '$Thana_code' AND birth_date BETWEEN '$Date' AND '$Date1' and brest_feeding='Yes' ");
$row=mysql_fetch_array($child2y);
$brest_feedingy=$row['coupleid'];
//brest_feedingn
$child2n =mysql_query("select count(couple_id) coupleid from pregnant_mum
WHERE thana_id = '$Thana_code' AND birth_date BETWEEN '$Date' AND '$Date1' and brest_feeding='No' ");
$row=mysql_fetch_array($child2n);
$brest_feedingn=$row['coupleid'];
//Total Delivery
$pmum_num=mysql_query("SELECT count( couple_id ) delivery FROM pregnant_mum
WHERE thana_id = '$Thana_code' AND birth_date BETWEEN '$Date' AND '$Date1'");
$rowD1=mysql_fetch_array($pmum_num);
$delivery_num1=$rowD1['delivery'];
//pnc1st visit
$resultcoupleid =mysql_query("select count(couple_id) coupleid from pregnant_mum
WHERE `birth_date`+INTERVAL 1 DAY Between '$Date' and '$Date1' and thana_id='$Thana_code' ");
$row=mysql_fetch_array($resultcoupleid);
$pnc1=$row['coupleid'];
$resultpnc1st =mysql_query("select count(pnc1st_visit) pnc1st from pregnant_mum
WHERE `birth_date`+INTERVAL 1 DAY Between '$Date' and '$Date1' and thana_id='$Thana_code' and pnc1st_visit='Yes' ");
$row1=mysql_fetch_array($resultpnc1st);
$pnc1y=$row1['pnc1st'];
$pnc1n=$pnc1-$pnc1y;
//pnc2nd visit
$resultcoupleid =mysql_query("select count(couple_id) coupleid from pregnant_mum
WHERE `birth_date`+INTERVAL 3 DAY Between '$Date' and '$Date1' and thana_id='$Thana_code' ");
$row=mysql_fetch_array($resultcoupleid);
$pnc2=$row['coupleid'];
$resultpnc2nd =mysql_query("select count(pnc2nd_visit) pnc2nd from pregnant_mum
WHERE `birth_date`+INTERVAL 3 DAY Between '$Date' and '$Date1' and thana_id='$Thana_code' and pnc2nd_visit ='Yes' ");
$row2=mysql_fetch_array($resultpnc2nd);
$pnc2y=$row2['pnc2nd'];
$pnc2n=$pnc2-$pnc2y;
//pnc3rd visit
$resultcoupleid =mysql_query("select count(couple_id) coupleid from pregnant_mum
WHERE `birth_date`+INTERVAL 14 DAY Between '$Date' and '$Date1' and thana_id='$Thana_code' ");
$row=mysql_fetch_array($resultcoupleid);
$pnc3=$row['coupleid'];
$resultpnc3rd =mysql_query("select count(pnc3rd_visit) pnc3rd from pregnant_mum
WHERE `birth_date`+INTERVAL 14 DAY Between '$Date' and '$Date1' and thana_id='$Thana_code' and pnc3rd_visit ='Yes' ");
$row3=mysql_fetch_array($resultpnc3rd);
$pnc3y=$row3['pnc3rd'];
$pnc3n=$pnc3-$pnc3y;
//pnc4th visit
$resultcoupleid =mysql_query("select count(couple_id) coupleid from pregnant_mum
WHERE `birth_date`+INTERVAL 42 DAY Between '$Date' and '$Date1' and thana_id='$Thana_code' ");
$row=mysql_fetch_array($resultcoupleid);
$pnc4=$row['coupleid'];
$resultpnc4th =mysql_query("select count(pnc4th_visit) pnc4th from pregnant_mum
WHERE `birth_date`+INTERVAL 42 DAY Between '$Date' and '$Date1' and thana_id='$Thana_code' and pnc4th_visit ='Yes' ");
$row4=mysql_fetch_array($resultpnc4th);
$pnc4y=$row4['pnc4th'];
$pnc4n=$pnc4-$pnc4y;
?>
District : echo $D_Name; ?>, Upazila/Thana : echo $T_Name;?>