format("Y-m-d"); //if submit/ save to databasevar if(isset($_POST['done'])){ $selectedProposalID = mysql_escape_string($_POST['selectedProposalID']); $exeItemID = mysql_escape_string($_POST['exeItemID']); mysql_query("UPDATE `prf_request_detl` SET `approved_proposal_code` = '$selectedProposalID' WHERE `id` = '$exeItemID'"); echo ''; } ?>