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"; 
                }

}