Quote:
<quote> my @data = $sth->fetchrow_array;

Then you have a nice array with all the elements of your sql return. Then just setup the select and itterate through this array like so: </quote>

My understanding of that is that @data now has one row of the select not the entire select (hence the name fetchrow).
<br< I think the problem is that you're only fetching a row once.

Here is some (untested) code:

my $sth = $dbh->prepare(select * from table) or die "$DBI::errstr\n";
$sth->execute() or die "$DBI::errstr\n";
while (my @array = $sth->fetchrow_array)
 {
 #do stuff with @array;
 }
[download]

This will grab all of the rows in the select.