$where = 'tfmglist'; break; default: break; } if ($agpmisagentpay == 0) { // $query = "UPDATE tb_".$table." SET fd_".$where."_isagentpay = '2' WHERE fd_".$where."_bkordernumber = '".$bkordernumber."'"; // $db->query($query); // $query1 = "UPDATE tb_agentpaymoneylist SET fd_agpm_isagentpay = '2' WHERE fd_agpm_bkordernumber = '".$bkordernumber."'"; // $db->query($query1); // file_put_contents("text.txt", $query1); // echo 'success'; $talbename = "tb_" . $table; $dataArray = array("fd_" . $where . "_isagentpay" => "2"); $whereArray = "fd_" . $where . "_bkordernumber = '" . $bkordernumber . "'"; $result1 = $db->update($talbename, $dataArray, $whereArray); unset($talbename); unset($dataArray); unset($whereArray); $talbename = "tb_agentpaymoneylist"; $dataArray = array("fd_agpm_isagentpay" => "2"); $whereArray = "fd_agpm_bkordernumber = '" . $bkordernumber . "'"; $result2 = $db->update($talbename, $dataArray, $whereArray); if ($result1 && $result2) { echo 'success'; } else { echo 'failure'; } } else { echo 'failure'; }