while (@dataf = $sthf->fetchrow_array())
    {
        $filiais[$xf] = $dataf[0];
        $xf++;
    }

##</code><code>##

$sth->execute;
$sth->bind_columns(\my $x, \my $y);
while ($sth->fetch) {
   # use $x and #y
}

##</code><code>##

my $sth = $dbh->prepare('select w from x where y = ? and z = ?');
$sth->execute($y, $z);