use DBI; my $dbh = DBI->connect(...); my $data = $dbh->selectall_arrayref(<<'__EOS__'); SELECT id, name, parent, first_son, next_brother, depth FROM family_tree WHERE ... __EOS__ my $count = @$data; print(<<"__EOS__"); Content-Type: text/html __EOS__ my $param = 1; foreach my $fields (@$data) { my $name = $param++; my $value = join('|', @$fields); print("\n"); } print("\n");