Method Distribution NGO

Back

User :

0){ $result7=mysql_query("SELECT * FROM distribution_details where thana_code='$Thana_code' and month_id='$Date'and ngo_code='$NGO_Id'"); $num1=mysql_num_rows($result7); $i=0; while ($i<$num1){ $num_id=1; $month_id=mysql_result($result7,$i,"month_id"); $thana_code=mysql_result($result7,$i,"thana_code"); $ngo_code=mysql_result($result7,$i,"ngo_code"); $oralPill=mysql_result($result7,$i,"oralPill"); $condom=mysql_result($result7,$i,"condom"); $inj_vial=mysql_result($result7,$i,"inj_vial"); $inj_siringe=mysql_result($result7,$i,"inj_siringe"); $iud_normal=mysql_result($result7,$i,"iud_normal"); $iud_pn=mysql_result($result7,$i,"iud_pn"); $iud_total=mysql_result($result7,$i,"iud_total"); $iud_remove=mysql_result($result7,$i,"iud_remove"); $implant_new=mysql_result($result7,$i,"implant_new"); $implant_remove=mysql_result($result7,$i,"implant_remove"); $ecp=mysql_result($result7,$i,"ecp"); $mizopostal=mysql_result($result7,$i,"mizopostal"); $per_male=mysql_result($result7,$i,"per_male"); $per_femalenormal=mysql_result($result7,$i,"per_femalenormal"); $per_femalepn=mysql_result($result7,$i,"per_femalepn"); $per_femaletotal=mysql_result($result7,$i,"per_femaletotal"); ++$i; } } else { $num_id=0; $month_id=$Date; $thana_code=$Thana_code; $ngo_code=$NGO_Id; $oralPill=""; $condom=""; $inj_vial=""; $inj_siringe=""; $iud_normal=""; $iud_pn=""; $iud_total=""; $iud_remove=""; $implant_new=""; $implant_remove=""; $ecp=""; $mizopostal=""; $per_male=""; $per_femalenormal=""; $per_femalepn=""; $per_femaletotal=""; } //Last Month $resultdate=mysql_query("SELECT Max(MONTH_ID) Maxdate FROM method_distribution where THANA_CODE='$Thana_code' and NGO_CODE='$NGO_Id'"); $rowD=mysql_fetch_array($resultdate); $M_Date=$rowD['Maxdate']; $VDate=date("F,Y",mktime(0,0,0,substr($M_Date,5,2),28,$H_Year)); //Thana Name $resultT=mysql_query("SELECT Thana_Name FROM thana where Thana_code='$Thana_code'"); $rowT=mysql_fetch_array($resultT); $T_Name=$rowT['Thana_Name']; $resultN=mysql_query("SELECT NGO_Name FROM ngo where NGO_code='$NGO_Id'"); $rowN=mysql_fetch_array($resultN); $N_Name=$rowN['NGO_Name']; //Month name $sql=mysql_query("select M_name from month where M_id='$m'"); $rowM=mysql_fetch_array($sql); $M_Name=$rowM['M_name']; ?>

District :	Upazilla/Thana :	Reporting Month :	Year :
NGO Name :			Last Entry Month:-

Method Distribution
Oralpill (cycle)	Condom (Pieces)	Injectable		IUD				Implant		ECP	Misoprostol
		Vial	Syringe	New			Remove	New	Remove
				Normal	PostNatal	Total
3	4	5	6	7	8	9	10	11	12	13	14

Method Performed
Permanent Method
Male	Female
	Normal	Post Natal	Total
15	16	17	18