format("Y/m/d"); //$toTime =Explode(":", date('H:i:s')); //$expirationDate = date('Y/m/d', strtotime($toDate. ' + 3 days')); //error_reporting(0); $code = 0; if(isset($_POST['done'])){ $selectedVIN = mysql_real_escape_string($_POST['selectedVIN']); $brandCSNumber = mysql_real_escape_string($_POST['brandCSNumber']); $EditRecordID = mysql_real_escape_string($_POST['EditRecordID']); $BrandSellingDealer = mysql_real_escape_string($_POST['BrandSellingDealer']); $BrandLocation = mysql_real_escape_string($_POST['BrandLocation']); $brandDesc = mysql_real_escape_string($_POST['brandDesc']); $brandYear = mysql_real_escape_string($_POST['brandYear']); if($BrandSellingDealer!=''){ $code = 1; } if($BrandLocation!=''){ $code = 2; } if ($BrandSellingDealer!='' && $BrandLocation!=''){ $code = 8; } switch($code){ case '1': mysql_query("UPDATE `db_vehicle_inventory` SET `year_model`='$brandYear',`cs_number`='$brandCSNumber', `description`='$brandDesc', `selling_dealer`='$BrandSellingDealer' WHERE `id` = '$EditRecordID'"); break; case '2': mysql_query("UPDATE `db_vehicle_inventory` SET `year_model`='$brandYear', `cs_number`='$brandCSNumber', `description`='$brandDesc', `unit_location`='$BrandLocation' WHERE `id` = '$EditRecordID'"); break; case '8': mysql_query("UPDATE `db_vehicle_inventory` SET `year_model`='$brandYear', `cs_number`='$brandCSNumber', `description`='$brandDesc', `selling_dealer`='$BrandSellingDealer',`unit_location`='$BrandLocation' WHERE `id` = '$EditRecordID'"); break; case '0': mysql_query("UPDATE `db_vehicle_inventory` SET `year_model`='$brandYear', `cs_number`='$brandCSNumber', `description`='$brandDesc' WHERE `id` = '$EditRecordID'"); break; } echo "

UNIT INFORMATION HAS BEEN UPDATED

"; exit(); } ?>