my $sql_is = qq{ SELECT count(*) FROM files WHERE (geo="$geo" AND lob="is" AND country="$key") };

##</code><code>##

$query_is = $dbh->prepare($sql_is);
$query_is->execute();
$query_is->bind_columns(\$count_is);

while ( @row = $query_is->fetchrow_array ) {
    #print "@row\n";
}

print "<tr><td>$value<\/td><td>$count_is<\/td><td>&nbsp;<\/td><td>&nbsp;<\/td><td>&nbsp;<\/td><td>&nbsp;<\/td><td>&nbsp;<\/td><td>&nbsp;<\/td><\/tr>";