# Get address: $sth = $dbh->selectrow_array(qq{select * from `shippingAddresses` where `Id` = (select `mid` from `members` where `USERNAME` = ?)}); $sth->execute($_un); my $_addy = $sth->fetchrow_hashref(); $sth->finish();