for (my $i=0; $i<=$#id; $i++){ my $sth=$dbh->prepare("SELECT Data,Identifier,User,Version FROM ddts,delivery WHERE `User`=\"@user\" AND `Identifier`=\"$id[$i]\" AND delivery.Data=ddts.Data"); $sth->execute(); while (my ($data,$identifier,$user,$version)=$sth->fetchrow_array ) { print "