쿼리문을 조건에 따라 추가하여 값을 출력하고 싶습니다 채택완료

<?php

include_once('./_common.php');

 

$table=$_POST['tbl'];

$diseaseTarget=$_POST['diseaseTarget'];

$validityTarget=$_POST['validityTarget'];

$drugTarget=$_POST['drugTarget'];

$companyTarget=$_POST['companyTarget'];

$speciesTarget=$_POST['speciesTarget'];

 

if($table === "FISH_DRUG"){

 

  $sql = "SELECT DISTINCT DRUG_NAME 

            FROM ".$table.", ADMINISTRATION_METHOD, FISH_DISEASE, ACTIVE_INGREDIENTS_BY_DRUG, ACTIVE_INGREDIENT, MANUFACTURING_COMPANY, FISH_SPECIES

           WHERE  FISH_DRUG.DRUG_NAME LIKE '%".$drugTarget."%'

             AND FISH_DRUG.DRUG_CODE = ADMINISTRATION_METHOD.DRUG_CODE ";

  

  if(!($diseaseTarget === "")){

    $sql .= "AND FISH_DISEASE.DISEASE_CODE = ADMINISTRATION_METHOD.DISEASE_CODE

             AND FISH_DISEASE.DISEASE_NAME_KR = '".$diseaseTarget."'";

  }

  if(!($validityTarget === "")){

    $sql .= "AND FISH_DRUG.DRUG_CODE = ACTIVE_INGREDIENTS_BY_DRUG.DRUG_CODE 

             AND ACTIVE_INGREDIENT.INGREDIENT_CODE = ACTIVE_INGREDIENTS_BY_DRUG.ACTIVE_INGREDIENT_CODE

             AND ACTIVE_INGREDIENT.INGREDIENT_NAME = '".$validityTarget."'";

  }

  if(!($companyTarget === "")){

    $sql .= "AND FISH_DRUG.MANUFACTURING_COMPANY_CODE = MANUFACTURING_COMPANY.COMPANY_CODE 

             AND MANUFACTURING_COMPANY.COMPANY_NAME = '".$companyTarget."'";

  }

  if(!($speciesTarget === "")){

    $sql .= "AND FISH_SPECIES.SPECIES_CODE = ADMINISTRATION_METHOD.SPECIES_CODE 

             AND FISH_SPECIES.SPECIES_NAME = '".$speciesTarget."'";

  }

  $result = sql_query($sql);