$transaction_query = "INSERT INTO `transaction` (`tr_type`, `tr_desc`, `tr_date`, `tr_user_id`) VALUES ('DELETE', 'vehicle_modification-{$moddi_id}', '{$today}', '{$_SESSION['user_id']}')"; mysql_query("START TRANSACTION"); $delete = mysql_query($delete_query); $transaction = mysql_query($transaction_query); if ($delete && $transaction) { mysql_query('COMMIT'); echo json_encode(array(array("msgType" => 1, "msg" => "Successfully Deleted."))); } else { mysql_query('ROLLBACK'); echo json_encode(array(array("msgType" => 2, "msg" => "Cannot Be Deleted."))); } MainConfig::closeDB(); } else { if ($_POST['action'] == 'get_photo_count') { $vh_id = $_POST['vh_id']; $system->prepareSelectQueryForJSONSingleData("SELECT COUNT(vehicle_photo.ph_id) AS ph_count\nFROM vehicle INNER JOIN vehicle_photo ON vehicle_photo.vh_id = vehicle.vh_id\nWHERE vehicle_photo.vh_id = '{$vh_id}'"); } else { if ($_POST['action'] == 'add_temp_entry') { $data = $_POST['vh_data']; mysql_query("START TRANSACTION"); // delete mysql_query("DELETE FROM proforma_inv WHERE proforma_inv.pi_date < CURRENT_DATE () AND proforma_inv.pi_status = '98'"); mysql_query("INSERT INTO `proforma_inv` ( `pi_date`, `cus_id`, `pi_status` ) VALUES (CURRENT_DATE(), 0, '98');"); $ref_id = mysql_insert_id(); // echo $ref_id; if (!empty($data) && $ref_id > 0) { foreach ($data as $key => $value) { $price_res = mysql_query("SELECT IF(vehicle.auc_display_price=0,vehicle.auc_real_price,vehicle.auc_display_price) AS vh_price\n FROM vehicle\n WHERE vehicle.vh_id = '{$value}'"); $vh_price = mysql_fetch_assoc($price_res); // $ins = mysql_query("INSERT INTO `temp_entries` (`temp_id`, `sel_id`) VALUES ({$ref_id},'{$value}');") or die(mysql_error()); $ins = mysql_query("INSERT INTO `pi_entries` (`pi_id`, `vh_id`) VALUES ({$ref_id},'{$value}');") or die(mysql_error());