sub insertsql {
    my ($dbh,$table,$data,$ignore) = @_;
    my @qm;
    my @keys;
    my @values;
    my $i = -1;
    foreach my $k (keys %$data) {
        if (defined($data->{$k})) {
            $i++;
            $keys[$i] = $k;
            $values[$i] = $data->{$k};
            $qm[$i] = '?';
        }
    }
    my $keylist = join(",",@keys);
    my $qlist = join(",",@qm);
    my $sqlstatement = "insert into $table ($keylist) values ($qlist)";
    if ($ignore) {
        my $sqlstatement = "insert ignore into $table ($keylist) values ($qlist)";
    }
    
    my $sth = $dbh->prepare($sqlstatement);
    #$sth->execute(@values) || die "putsql could not execute MySQL statement: $sqlstatement $sth->errstr";
    $sth->execute(@values) || die $sth->errstr;
    $sth->finish();
    return $dbh->{'mysql_insertid'};
}