$sql="select sum(male) As total_male1 ,sum(female) As total_female1
from report_day WHERE report_dept ='MFG1'AND date_report='$date'";
$query =mysql_query($sql);
$row= mysql_fetch_array($query);
$sql="select sum(male) As total_male2,sum(female) As total_female2
from report_day WHERE report_dept ='BASE 3.5 (MFG1)' AND date_report='$date'";
$query =mysql_query($sql);
$row= mysql_fetch_array($query);