my @rows; foreach $Old_URL (@Old_URL) { chomp $Old_URL; @rows = ED::database->execute_query("select new_url from convertedURL where old_url = 'http://www.ed.gov/PressReleases/01-20 03/index.html'"); $rowcount = @rows; } print "\n"; foreach $row (%rows) { print keys($row); } print "\n"; print "\n";