my $sth=$dbh->prepare("SELECT * FROM ddts WHERE `Stat`=? AND `Project`=? AND `Version`=?"); $sth->execute("T","Def",join(@version)); #### y @compile=param ('compile'); my $dbh=DBI->connect($dsn,$user,$password,) or die "Error $DBI:: error connecting to $dsn"; my $sth=$dbh->prepare("SELECT * FROM ddts WHERE `Stat`=? AND `Project`=? AND `Version`=?"); $sth->execute("T","Def",join(@version)); print ""; while (my ($identifier) = $sth->fetchrow_array ) { foreach $elem (@compile) { if ($elem eq $identifier){ print "
1696
"; print ""; } } } print "
$identifier
"; $sth->finish;