$mysql->query(qq{SELECT * FROM protein WHERE accession_code = '$accession_code'}); print $mysql->has_selected_record(), "\n"; if ($mysql->has_selected_record() == 1) { $id = $mysql->query (qq{INSERT INTO protein (accession_code, name_of_protein, length_of_protein) VALUES('$accession_code', '$name_of_protein', '$length_of_protein')}); print "return value insert protein: ", $id, "\n"; $id_pep = $mysql->query(qq{INSERT INTO peptide (startpos_in_proteinseq, endpos_in_proteinseq, peptide_seq, expect_val, length_of_peptideseq) VALUES ('$startpos_in_proteinseq', '$endpos_in_proteinseq', '$peptide_seq', '$expect_val', '$length_of_peptideseq')}); print "return value insert peptide: ", $id_pep, "\n"; print "Affected row:", $mysql->get_affected_rows_length, "\n"; # print $mysql->get_error_message if $mysql->is_error, "\n"; print "\n"; } else { print "don't do anything, ENTRY !!!!!!!! is already in the database \n"; }