http://www.perlmonks.org?node_id=987105


in reply to An Array Without and Index

All arrays have an index, so that's not the problem here. Other people have given you good advice about using placeholders, moving your prepare statement outside your loop, etc. But to narrow down your problem, try adding some debugging statements, like this:

print "Fetching values for $addr\n"; while (my @row = $stm->fetchrow_array){ print " Got values: ", join( ':', @row ), "\n"; push (@results, @row); } $stm->finish; print "Finished getting values, printing \@results for $addr:\n"; print join ':', @results; print "\n\n";

Aaron B.
Available for small or large Perl jobs; see my home node.