199 AND `bfr` < 251 AND `branch_id`='$compCode' AND `creatinine` < 10 "),0);
$bfrTwoHundredFiftyToThreeHundred=mysql_result(mysql_query("SELECT COUNT('lab_id') FROM `laboratory_info` WHERE `lab_date` BETWEEN '$startDate' AND '$endDate' AND `bfr` > 250 AND `bfr` < 299 AND `branch_id`='$compCode' AND `creatinine` < 10 "),0);
$bfrAboveThreeHundred=mysql_result(mysql_query("SELECT COUNT('lab_id') FROM `laboratory_info` WHERE `lab_date` BETWEEN '$startDate' AND '$endDate' AND `bfr` > 300 AND `branch_id`='$compCode' AND `creatinine` < 10 "),0);
//QUERY BFR WITH LESS 200 VALUE AND CREATININE LESS 10-19.9
$bfrLessTwoHundredB=mysql_result(mysql_query("SELECT COUNT('lab_id') FROM `laboratory_info` WHERE `lab_date` BETWEEN '$startDate' AND '$endDate' AND `bfr` < 200 AND `branch_id`='$compCode' AND `creatinine` < 20 AND `creatinine` > 9 "),0);
$bfrTwoHundredOneToThreeHundredB=mysql_result(mysql_query("SELECT COUNT('lab_id') FROM `laboratory_info` WHERE `lab_date` BETWEEN '$startDate' AND '$endDate' AND `bfr` > 199 AND `bfr` < 251 AND `branch_id`='$compCode' AND `creatinine` < 20 AND `creatinine` > 9 "),0);
$bfrTwoHundredFiftyToThreeHundredB=mysql_result(mysql_query("SELECT COUNT('lab_id') FROM `laboratory_info` WHERE `lab_date` BETWEEN '$startDate' AND '$endDate' AND `bfr` > 250 AND `bfr` < 299 AND `branch_id`='$compCode' AND `creatinine` < 20 AND `creatinine` > 9 "),0);
$bfrAboveThreeHundredB=mysql_result(mysql_query("SELECT COUNT('lab_id') FROM `laboratory_info` WHERE `lab_date` BETWEEN '$startDate' AND '$endDate' AND `bfr` > 300 AND `branch_id`='$compCode' AND `creatinine` < 20 AND `creatinine` > 9 "),0);
//QUERY BFR WITH LESS 20 VALUE AND CREATININE LESS 30
$bfrLessTwoHundredC=mysql_result(mysql_query("SELECT COUNT('lab_id') FROM `laboratory_info` WHERE `lab_date` BETWEEN '$startDate' AND '$endDate' AND `bfr` < 200 AND `branch_id`='$compCode' AND `creatinine` > 19.99 AND `creatinine` < 31 "),0);
$bfrTwoHundredOneToThreeHundredC=mysql_result(mysql_query("SELECT COUNT('lab_id') FROM `laboratory_info` WHERE `lab_date` BETWEEN '$startDate' AND '$endDate' AND `bfr` > 199 AND `bfr` < 251 AND `branch_id`='$compCode' AND `creatinine` > 19.99 AND `creatinine` < 31 "),0);
$bfrTwoHundredFiftyToThreeHundreC=mysql_result(mysql_query("SELECT COUNT('lab_id') FROM `laboratory_info` WHERE `lab_date` BETWEEN '$startDate' AND '$endDate' AND `bfr` > 250 AND `bfr` < 299 AND `branch_id`='$compCode' AND `creatinine` > 19.99 AND `creatinine` < 31 "),0);
$bfrAboveThreeHundreC=mysql_result(mysql_query("SELECT COUNT('lab_id') FROM `laboratory_info` WHERE `lab_date` BETWEEN '$startDate' AND '$endDate' AND `bfr` > 300 AND `branch_id`='$compCode' AND `creatinine` > 19.99 AND `creatinine` < 31 "),0);
//QUERY BFR WITH ABOVE 30
$bfrLessTwoHundredD=mysql_result(mysql_query("SELECT COUNT('lab_id') FROM `laboratory_info` WHERE `lab_date` BETWEEN '$startDate' AND '$endDate' AND `bfr` < 200 AND `branch_id`='$compCode' AND `creatinine` > 30 "),0);
$bfrTwoHundredOneToThreeHundredD=mysql_result(mysql_query("SELECT COUNT('lab_id') FROM `laboratory_info` WHERE `lab_date` BETWEEN '$startDate' AND '$endDate' AND `bfr` > 199 AND `bfr` < 251 AND `branch_id`='$compCode' AND `creatinine` > 30 "),0);
$bfrTwoHundredFiftyToThreeHundredD=mysql_result(mysql_query("SELECT COUNT('lab_id') FROM `laboratory_info` WHERE `lab_date` BETWEEN '$startDate' AND '$endDate' AND `bfr` > 250 AND `bfr` < 299 AND `branch_id`='$compCode' AND `creatinine` > 30 "),0);
$bfrAboveThreeHundredD=mysql_result(mysql_query("SELECT COUNT('lab_id') FROM `laboratory_info` WHERE `lab_date` BETWEEN '$startDate' AND '$endDate' AND `bfr` > 300 AND `branch_id`='$compCode' AND `creatinine` > 30 "),0);
?>