....... my $dsn = "dbi:$platform:$database:$host:$port"; my $connect = DBI->connect($dsn, $user, $pw); foreach my $k(@shows_array) { my($show_id,$title,$next_episode) = split(/\|/,$k); my $query = "SELECT count(episode) from shows where episode = \"$next_episode\""; my $query_handle = $connect->prepare($query); $query_handle->execute(); $query_handle->bind_columns(\$episode); { if($episode eq "0") { $get_file = "$url$title"." "."$next_episode"."&catid=$catid"."&num=".$num."&age="."$age"."&username=".$username."&".$apikey; #print "
".$get_file."
"; #THE PRINT ABOVE OUTPUTS FINE push(@nzb_list,$get_file); print @nzb_list; #THE PRINT ABOVE IS THE PROBLEM }; } }