Contraceptive Acceptors and Acceptance Rate (CAR%) Performed by NGO
$result = mysql_query("select ngo.ngo_code,Month_Id,Sum(Total_EC) EC,
(Sum(car_ngo.Pill_Old)+Sum(car_ngo.Pill_New)) Pill,
(Sum(car_ngo.Con_Old)+Sum(car_ngo.Con_New)) Con,
(Sum(car_ngo.Inj_Old)+Sum(car_ngo.Inj_New)) Inj,
(Sum(car_ngo.IUD_Old)+Sum(car_ngo.IUD_New)) IUD,
(Sum(car_ngo.Imp_Old)+Sum(car_ngo.Imp_New)) Imp,
(Sum(car_ngo.PerM_Old)+Sum(car_ngo.PerM_New)) PerM,
(Sum(car_ngo.PerF_Old)+Sum(car_ngo.PerF_New)) PerF,
(Sum(car_ngo.PerM_Old)+Sum(car_ngo.PerM_New)+Sum(car_ngo.PerF_Old)+Sum(car_ngo.PerF_New)) TPer,
(Sum(car_ngo.Pill_Old)+Sum(car_ngo.Pill_New))+
(Sum(car_ngo.Con_Old)+Sum(car_ngo.Con_New))+
(Sum(car_ngo.Inj_Old)+Sum(car_ngo.Inj_New))+
(Sum(car_ngo.IUD_Old)+Sum(car_ngo.IUD_New))+
(Sum(car_ngo.Imp_Old)+Sum(car_ngo.Imp_New))+
(Sum(car_ngo.PerM_Old)+Sum(car_ngo.PerM_New)+Sum(car_ngo.PerF_Old)+Sum(car_ngo.PerF_New)) TUser,
(((Sum(car_ngo.Pill_Old)+Sum(car_ngo.Pill_New))+
(Sum(car_ngo.Con_Old)+Sum(car_ngo.Con_New))+
(Sum(car_ngo.Inj_Old)+Sum(car_ngo.Inj_New))+
(Sum(car_ngo.IUD_Old)+Sum(car_ngo.IUD_New))+
(Sum(car_ngo.Imp_Old)+Sum(car_ngo.Imp_New))+
(Sum(car_ngo.PerM_Old)+Sum(car_ngo.PerM_New)+Sum(car_ngo.PerF_Old)+Sum(car_ngo.PerF_New)))
/Sum(car_ngo.Total_EC))*100 CAR
from ngo,car_ngo
Where (car_ngo.ngo_code=ngo.ngo_code)
And (Month_Id Between '$Date' and '$Date1' )
AND car_ngo.ngo_code='$ngo_code' And car_ngo.thana_code='$Thana_id'
Group By ngo.ngo_code ,Month_Id Order By Month_Id");
$num=mysql_num_rows($result);
?>
Contraceptive Acceptors and Acceptance Rate (CAR%) by Month at Upazila Level Performed by NGO
NGO: Upazila: District:
Reporting Period: , From
,