$workSQL = "SELECT * FROM workorder WHERE 1 ";
if ($_POST["ddlSelect"] != "" and $_POST["txtKeyword"] != '')
{
if($_POST["ddlSelect"] == "worker1")
{
$workSQL .= " AND (worker1 LIKE '%".$_POST["txtKeyword"]."%' or worker2 LIKE '%".$_POST["txtKeyword"]."%' or worker3 LIKE '%".$_POST["txtKeyword"]."%' or worker4 LIKE '%".$_POST["txtKeyword"]."%' )";
}
else
{
$workSQL .= " AND (".$_POST["ddlSelect"]." LIKE '%".$_POST["txtKeyword"]."%' )";
}
}