<?php
    include_once("../../cfg/db.php");
    $id = $db->escape(trim($_POST['variant_id']));

    $new_variant_name = $db->escape(trim(strtoupper($_POST['new_variant_name'])));
    $new_variants_model = $db->escape(trim($_POST['new_variants_model']));

    if(intval($db -> select("SELECT count(1) FROM source_car_model_variant WHERE `name` = '$new_variant_name' AND id != '$id'")) > 0){
        $arr['status'] = 0; //duplicate variant name
    } 
    else {
        $update_query = "UPDATE `source_car_model_variant` SET `name`='$new_variant_name', `car_model_id`='$new_variants_model' WHERE `id` = '$id'";
        $db->sql_query($update_query);

        $arr['status'] = 2; //success update
    }

    echo json_encode($arr);
?>