format("Y/m/d"); $toTime =Explode(":", date('H:i:s')); //if submit/ save to database if(isset($_POST['done'])){ $csRelease = mysql_real_escape_string($_POST['csRelease']); $selectedVIN = mysql_real_escape_string($_POST['selectedVIN']); $releasedComment = mysql_real_escape_string($_POST['releasedComment']); $SelAgent = mysql_real_escape_string($_POST['SelAgent']); $SelCompany = mysql_real_escape_string($_POST['SelCompany']); $EditRecordID = mysql_escape_string($_POST['EditRecordID']); mysql_query("UPDATE `db_vehicle_inventory` SET `sold`='1', `remarks`='$releasedComment', `status`='Sold', `date_released`='$toDate', `released_by`='$SelAgent', `released_by_comp`='$SelCompany' WHERE `id`='$EditRecordID'"); echo "

UNIT HAS BEEN TAG AS SOLD

"; exit(); } ?>