$sth = $dbh->prepare( " SELECT * FROM csvtable WHERE SITE LIKE ? AND HOUR = ? " ); foreach my $key (keys %cell_peakhr) { $sth->execute( $key, $cell_peakhr{$key}); @db_result = $sth->fetchrow_array() if (scalar(@db_result) < 1) { $db_result[0] = $date; $db_result[1] = $cell_peakhr{$key}; $db_result[2] = $key; foreach my $count (3..$row_size-1) { $db_result[$count] = "-"; }#foreach }#if print OUT join(',',@db_result)."\n"; }