$update = $dbh->prepare("UPDATE snp_db SET chr_position=?, band=?, alleles=?, etc=? WHERE rs=$whatever"); $update->execute($val, $val2, $val3, $etcval);