$sth = $dbh->prepare("UPDATE snp_db SET (chr_position,band,alleles,het,validated,gene,role,relative_pos,aa_change,flanking_seq) VALUES (?,?,?,?,?,?,?,?,?) WHERE rs = $rs_number;");

$sth->execute($position,$band,$alleles,$het,$val,$gene,$role,$pos,$aa);