function UpdateStatus($custId) { $query = " select * from customer where customer_id='" . $custId . "'"; $conn = new MyDb(); $conn->Query($query); $array = $conn->GetRecord(); $status = $array["customer_status"]; if ($status == constant("CUSTOMER_DENY")) { $status = constant("CUSTOMER_PASS"); } else { $status = constant("CUSTOMER_DENY"); } $sql = "update customer set customer_status='" . $status . "' where customer_id='" . $custId . "'"; $id = $conn->UpdateData($sql); $conn->Close(); return $id; }