Help for this page

Select Code to Download


  1. or download this
    $sth = $dbh->prepare("INSERT INTO snp_db (rs,chr_position,band,alleles
    +,het,validated,gene,role,relative_pos,aa_change,flanking_seq) VALUES 
    +(?,?,?,?,?,?,?,?,?,?);");
    
    $sth->execute($rs_number,$position,$band,$alleles,$het,$val,$gene,$rol
    +e,$pos,$aa);
    
  2. or download this
    $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)
    +;