mysql - SQL syntax; check the manual that corresponds to your MariaDB server version - delete query -

i can't tell wrong here, have tried replacing id = '$id' , still not working. removing clause makes works fine. id variable not have problem has it's value. can me figure out? thanks

  $id = $_get['id'];    $status = $con->exec("update wine set confirmstatus = 'confirmed' id = '".$id."' "); 

try without enclosing $id- value within ' ':

  $status = $con->exec("update wine set confirmstatus = 'confirmed' id = ".$id); 

if works, please still consider gordon's comment regarding using parameters...