Select Code to Download

 my $select = $dbh->prepare("select path from application_table where 
+number = ? ORDER BY some_other_number");

...
                        print "path: $_\n";
        }
}

 my $select = $dbh->prepare("select path from application_table where 
+number = ? ORDER BY some_other_number");

...
while(my($path) = $select->fetchrow_array) {
    print "PATH: $path\n";
}