} else {
$sql_nid = $db->query("select * from member_log where member_user_name='".trim($_POST["tuname"])."'");
if($db->countRows($sql_nid) == 1){ messege("New Username Is Not Available!"); redirect('Registration.php'); }
$new_resid=trim($_POST["tuname"]);
$sql_pid = $db->query("select * from member_log where member_user_name='".trim($_POST["txtsponid"])."'");
if($db->countRows($sql_pid) == 0){ messege("Sponsor ID Is Not Available!"); redirect('Registration.php'); }
else { $sql_sp_aid = $db->fetch($sql_pid);
$sql_pid_nme = $db->fetch($db->query("select * from member_detail where member_id='".$sql_sp_aid["member_id"]."'")); } ?>
} ?>