while (($line) = $sth->fetchrow_array()) {
                 push(@all_rows, $line);
        }
        foreach (@all_rows) {
                print "$_\n";
       }