my $info = $dbh->prepare("SELECT count(*) FROM
  details as m
  JOIN users as snd ON snd.user_id = m.username WHERE snd.location = ?");
$info->execute($location);
my $Count = $info->fetchall_arrayref();

foreach my $total_info(@$Count) {
print $total_info;
}