$sth=$dbh->prepare("UPDATE INV SET SOLD=? WHERE CODE==?"); $sth->execute($updy,$CODE); # Why is that var all UPcase, BTW?