用PHP更新数据库

<?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "dhandhar";
$conn = new mysqli($servername, $username, $password, $dbname);

?>
<?php
$id=$_GET['id'];

$name=$_POST['name']; 
$fathers_name=$_POST['fathers_name'];
$gotra=$_POST['gotra'];
$image=$_POST['image'];
$village=$_POST['village'];
$company_name=$_POST['company_name'];
$address1=$_POST['address1'];
$address2=$_POST['address2'];
$city=$_POST['city'];
$pincode=$_POST['pincode'];
$mobile1=$_POST['mobile1'];
$mobile2=$_POST['mobile2'];
$village_number=$_POST['village_number'];

if($_POST['edit2'])
{
$sql = "UPDATE members_data SET name='$name', fathers_name='$fathers_name', gotra='$gotra', image='$image', village=$village', company_name='$company_name', address1='$address1', address2='$address2', city='$city', pincode='$pincode', mobile1='$mobile1', mobile2='$mobile2', village_number='$village_number' )VALUES('$name', '$fathers_name', '$gotra', '$image', '$village', '$company_name', '$address1', '$address2', '$city', '$pincode', '$mobile1', '$mobile2', '$village_number' WHERE id= '".$id."'";
if (mysqli_query($conn, $sql)) {
echo "New record created successfully";
} else {
echo "Error: " . $sql . "<br>" . mysqli_error($conn);
}


$sql = "DELETE FROM edit_members_data WHERE id= '".$id."'";

if ($conn->query($sql) === TRUE) {
echo "Record deleted successfully";
} else {
echo "Error deleting record: " . $conn->error;
$conn->close();
}
}
?>
<script type="text/javascript">window.location="admin_approve.php"</script>

我收到以下错误：

错误：更新members_data SET名称=“名称测试”，fathers_name =“测试名称”，gotra =“ NA”，图像=“ award3.jpg”，village = NA'，company_name =“ test_company”，address1 =“测试地址” ，address2 =''，city ='test City'，pincode ='test pincode'，mobile1 ='000'，mobile2 ='000'，village_number =“''）VALUES（'名称测试'，'测试名称'，' NA'，'award3.jpg'，'NA'，'test_company'，'test地址'，''，'test City'，'test pincode'，'000'，'000'，'WHERE id ='2 '您的SQL语法有误；请在与您的MySQL服务器版本相对应的手册中找到正确的语法，以在''，company_name ='test_company'，address1 ='附近使用测试地址'，address2 =''，city ='test'在第1行记录已成功删除