CAR For NGO

Back

CAR For NGO

User :

0){ $result7=mysql_query("SELECT * FROM car_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"); $Total_EC=mysql_result($result7,$i,"Total_EC"); $Pill_Old=mysql_result($result7,$i,"Pill_Old"); $Pill_New=mysql_result($result7,$i,"Pill_New"); $Pill_Drop=mysql_result($result7,$i,"Pill_Drop"); $Pill_Switch=mysql_result($result7,$i,"Pill_Switch"); $Con_Old=mysql_result($result7,$i,"Con_Old"); $Con_New=mysql_result($result7,$i,"Con_New"); $Con_Drop=mysql_result($result7,$i,"Con_Drop"); $Con_Switch=mysql_result($result7,$i,"Con_Switch"); $Inj_Old=mysql_result($result7,$i,"Inj_Old"); $Inj_New=mysql_result($result7,$i,"Inj_New"); $Inj_Drop=mysql_result($result7,$i,"Inj_Drop"); $Inj_Switch=mysql_result($result7,$i,"Inj_Switch"); $IUD_Old=mysql_result($result7,$i,"IUD_Old"); $IUD_New=mysql_result($result7,$i,"IUD_New"); $IUD_Drop=mysql_result($result7,$i,"IUD_Drop"); $IUD_Switch=mysql_result($result7,$i,"IUD_Switch"); $Imp_Old=mysql_result($result7,$i,"Imp_Old"); $Imp_New=mysql_result($result7,$i,"Imp_New"); $Imp_Drop=mysql_result($result7,$i,"Imp_Drop"); $Imp_Switch=mysql_result($result7,$i,"Imp_Switch"); $PerM_Old=mysql_result($result7,$i,"PerM_Old"); $PerM_New=mysql_result($result7,$i,"PerM_New"); $PerF_Old=mysql_result($result7,$i,"PerF_Old"); $PerF_New=mysql_result($result7,$i,"PerF_New"); ++$i; } } else { $num_id=0; $Month_Id=$Date; $Thana_code=$Thana_id; $NGO_code=$NGO_Id; $Total_EC=""; $Pill_Old=""; $Pill_New=""; $Pill_Drop=""; $Pill_Switch=""; $Con_Old=""; $Con_New=""; $Con_Drop=""; $Con_Switch=""; $Inj_Old=""; $Inj_New=""; $Inj_Drop=""; $Inj_Drop=""; $Inj_Switch=""; $IUD_Old=""; $IUD_New=""; $IUD_Drop=""; $IUD_Switch=""; $Imp_Old=""; $Imp_New=""; $Imp_Drop=""; $Imp_Switch=""; $PerM_old=""; $PerM_New=""; $PerF_old=""; $PerF_New=""; } //end if //Last Month Entry-- $resultdate=mysql_query("SELECT Max(Month_id) Maxdate FROM car_details where Thana_code='$Thana_id' and NGO_Code='$NGO_Id'"); $rowD=mysql_fetch_array($resultdate); $M_Date=$rowD['Maxdate']; $resultD=mysql_query("SELECT Dist_Name FROM district where Dist_code='$Dist_Id'"); $rowD=mysql_fetch_array($resultD); $D_Name=$rowD['Dist_Name']; //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 :	Upazila/Thana :	Reporting Month :	Year :
NGO Name :

Eligible Couple

Last Month Entry::-

Method	Old	New	Total	No Method	Switch over
Oral Pill
Condom
Injectable
I U D
Implant
Per.Method(Male)
Per.method(Female)