query("UPDATE oder SET status ='" . $status . "',card_sta ='" . $card_sta . "', beizhu='" . $beizhu . "'where id=" . $id); if ($data > 0) { echo " "; } else { // echo "Error updating record: " . $con->error; echo " "; } } $sql = "UPDATE revenue SET oder_sta = '$status' WHERE oderid = '$oderid'"; if ($con->query($sql) === TRUE) { // echo "Record updated successfully"; } else { // echo "Error updating record: " . $con->error; } $con->close(); ?>