| numbers |  type |
-------------------
|   2     |  ac   |
|   3     |  dc   |
|   4     |  ca   |
|   4     |  md   |
|   5     |  ae   |
|   6     |  ce   |
|   7     |  da   |
|   8     |  ac   |
___________________

##</code><code>##

my $type;
my $sth = $dbh->prepare_cached(<<SQL);
SELECT type from dogs where number = ?
SQL
foreach $number (@num_range) {

		$sth->execute($number);
		$sth_x->bind_columns(undef, \$type);

                while ($sth->fetch) {
                    print "$num: $type"; 
                }

}