$qry = "UPDATE kullanici SET bakiye = (bakiye - :bakiye) WHERE id = $id;"; $stmt = $db->prepare($qry); $stmt->execute(array(':bakiye' => $teklif));