$refferal[0] = "1|2|3|4" #first refferals $refferal[1] = "1|2|3|4|5|6" #second refferals $refferal[2] = "1|2|3" #third refferals #### #Get Reffers my @ref; (@reffer) = build_reffers($mem_info[2]); ## Build Refferal List sub build_reffers { $REF = shift; $sth = $dbh->prepare("SELECT username FROM wbwm_members WHERE refferal='$REF'"); $sth->execute; while($username = $sth->fetchrow_array) { push(@users, $username); } $users = join(/\|/, @users); push(@ref, $users); foreach $name (@users) { build_reffers($name); } return(@ref); } #### foreach $name (@users) { build_reffers($name); }