INNER JOIN ".ucwords($classification)."ActualUses ON ".ucwords($classification).".actualUse = ".ucwords($classification)."ActualUses.".$classification."ActualUsesID GROUP BY ( ".$classification."ActualUsesID )"; else $sql ="SELECT ".ucwords($classification)."ActualUses.code as description, sum( ".ucwords($classification).".marketValue ) as total FROM AFS INNER JOIN ".ucwords($classification)." USING ( afsID ) INNER JOIN ".ucwords($classification)."ActualUses ON ".ucwords($classification).".actualUse = ".ucwords($classification)."ActualUses.".$classification."ActualUsesID LEFT JOIN Location ON AFS.odID = Location.odID LEFT JOIN LocationAddress ON Location.locationAddressID = LocationAddress.locationAddressID LEFT JOIN Barangay ON LocationAddress.barangayID = Barangay.barangayID WHERE AFS.archive != 'true' AND Barangay.barangayID = $brgyID GROUP BY ( ".$classification."ActualUsesID )"; $db->query($sql); if($db->num_rows() >0){ for($i=0;$db->next_record();$i++){ $total += $db->f("total"); $t[$i] = $db->f("total"); $barangay[$i] = $db->f("description"); } } /*for($i=0;$i<count($t);$i++){ $percentage[$i] = ($t[$i]/$total) * 100; }*/ //$vCht4 = array(1,20,20,34,5,52,41,20,34,43,64,40); // $vCht5 = array(12,21,36,27,14,23,3,5,29,23,12,5); // $vCht6 = array(5,7,3,15,7,8,2,2,2,11,22,3);