오류가 나는곳의 주소를 알려주시면 더 빠르고 정확하게 답변 받을 수 있습니다.

오류 주소 :

아래 내용은 친구목록에서 "내친구" 와 "친구추천" 리스트 페이지입니다.
각 홈피게시판등에서 홍길동이란 사람이 임꺽정을 친구로 저장을 하게되면
임꺽정은 이 페이지에 홍길동이란사람이 친구추천에 뜹니다.(현재는요....)

친구추천목록에서 내친구로 추가를 할경우 홍길동은 친구추천목록과 내친구 목록에 뜹니다.
이걸 친구추천을 하게되면 친구추천 목록에서는 제외되고 내친구목록에만 뜨게 하고 싶습니다.

즉, 친구추천 목록의 사람은 친구추가를 하면 친구추천목록에서 사라진다.입니다........

---------------------------------------------------------------------------------------------
<?
$g4_path = "../../..";
include_once ("$g4_path/common.php");
$g4[title] = "회원목록";
include_once("$g4[path]/head.sub.php");


if (!$member[mb_id]) {
    alert_close("로그인 하십시오.");
}

$member_skin_path = "$g4[path]/skin/member/$config[cf_member_skin]";

 if ($smenu == "b")
{
    $send_img = "btnr";
$send_imgc = "btns";
}
else if ($smenu == "c")
{
    $send_img = "btns";
$send_imgc = "btnr";
}


if ($smenu =="b"){
  $sql = " select * from $g4[member_table] a left join g4_memo_friend b on (b.mf_id = a.mb_id) where my_id = '$member[mb_id]' ";
}
else if ($smenu =="c")
{
  $sql = " select * from $g4[member_table] a left join g4_memo_friend b on (b.my_id = a.mb_id) where mf_id = '$member[mb_id]' ";
}
else
{
$sql_common = " from $g4[member_table]";
$sql_search = " where (1) ";
if ($stx) {
    $sql_search .= " and ( ";
    switch ($sfl) {
        case "mb_point" :
            $sql_search .= " ($sfl >= '$stx') ";
            break;
        case "mb_level" :
            $sql_search .= " ($sfl = '$stx') ";
            break;
        default :
            $sql_search .= " ($sfl like '$stx%') ";
            break;
    }
    $sql_search .= " ) ";
}

if ($is_admin == 'group')
    $sql_search .= " and mb_level = '$member[mb_level]' ";

if (!$sst) {
    $sst = "mb_datetime";
$sod = "desc";
}

 $sql_order = " order by $sst $sod ";
}


if ($smenu =="b"){
$sql = " select count(mb_id) as cnt from $g4[member_table] a left join g4_memo_friend b on (b.mf_id = a.mb_id) where my_id = '$member[mb_id]' ";
}
  else if ($smenu =="c"){
$sql = " select count(mb_id) as cnt from $g4[member_table] a left join g4_memo_friend b on (b.my_id = a.mb_id) where mf_id = '$member[mb_id]' ";
}
 else
 {
  $sql = " select count(*) as cnt
        $sql_common
        $sql_search
        $sql_order ";
 }


$row = sql_fetch($sql);
$total_count = $row[cnt];

$rows = $config[cf_page_rows];
$total_page  = ceil($total_count / $rows);  // 전체 페이지 계산
if (!$page) $page = 1; // 페이지가 없으면 첫 페이지 (1 페이지)
$from_record = ($page - 1) * $rows; // 시작 열을 구함



if ($smenu =="b"){
$sql = " select * from $g4[member_table] a left join g4_memo_friend b on (b.mf_id = a.mb_id) where my_id = '$member[mb_id]' order by mf_id desc limit $from_record, $rows ";
}
else if ($smenu =="c")
{
$sql = " select * from $g4[member_table] a left join g4_memo_friend b on (b.my_id = a.mb_id) where mf_id = '$member[mb_id]' order by my_id desc limit $from_record, $rows ";
 }
 else
{
$sql = " select *
          $sql_common
          $sql_search
          $sql_order
          limit $from_record, $rows ";
 }
$result = sql_query($sql);

$listall = "<a href='$_SERVER[PHP_SELF]'><img src=\"$g4[path]/img/bb-start.gif\" border=\"0\" align=\"absmiddle\"></a>";

// 내친구들 아이디 추출
function memo_friend($my_id, $mf_id, $mf_name, $page) {
    global $g4, $member_skin_path;

$sql_where = "where mf_id = '$mf_id' and my_id = '$my_id'";

$sql = " select * from g4_memo_friend
$sql_where
order by my_id";



$row3 = sql_fetch($sql);

if ($row3[mf_id] == $mf_id) {
$f_plus = "<a href=\"javascript:del('$member_skin_path/memo_frmember.php?w=d&mf_id=$mf_id&my_id=$my_id&smenu=b&page=$page');\" title=\"내친구 제외\"><img src='".$g4[path]."/img/b-frx.png' align='absmiddle'></a>";
} else {
$f_plus = "<a href=\"$member_skin_path/memo_frmember.php?w=u&mf_id=$mf_id&mf_name=$mf_name&my_id=$my_id&smenu=b&page=$page\" title=\"내친구 추가\"><img src='".$g4[path]."/img/b-fr+.png' align='absmiddle'></a>";
}

return $f_plus;
}


// 내친구수
$sql = " select count(*) as cnt from g4_memo_friend
            where my_id = '$member[mb_id]'
            order by mf_id";
$row = sql_fetch($sql);
if ($row[cnt] >0) {
$memo_friend_count = "(".$row[cnt]." 명)";
}else{
    $memo_friend_count = "";
}

// 친구추천수
$sql2 = " select count(*) as cnt from g4_memo_friend
            where mf_id = '$member[mb_id]'
            order by my_id";
$row2 = sql_fetch($sql2);
if ($row2[cnt] >0) {
$memo_friend_count2 = "+".$row2[cnt];
}else{
    $memo_friend_count2 = "";
}

?>

<script language="javascript" src="<?=$g4[path]?>/js/sideview.js"></script>

<script language="JavaScript">
var list_update_php = "<?=$g4[admin_path]?>/member_list_update.php";
var list_delete_php = "<?=$g4[admin_path]?>/member_list_delete.php";
</script>
<style type="text/css">
.stop9 {margin-top:10px;}
.stop14 {margin-top:14px;}
</style>
</head>

<center>
<div class="cc" style="width:650px;">

<div class="cc h50">
<div class="aleft bleft fontw b h44 lh40">내친구 <?=$memo_friend_count?></div>
<div class="aright bright h44"><img src="<?=$g4[path]?>/img/memo-off.png" align="absmiddle" title="쪽지" onClick="window.location.href='<?=$g4[bbs_path]?>/memo.php';" class="cu"><img src="<?=$g4[path]?>/img/fr-on.png" align="absmiddle" onClick="window.location.href='<?=$member_skin_path?>/member_list.php?smenu=b';" title="친구관리" class="cu"></div>
</div>



<div class="cc h36">
<div class="aleft bleft w100" style="margin-right:1px;"><input type="button" class="w100 text11 <?=$send_img?>" value="내친구" onclick="window.location.href='<?=$member_skin_path?>/member_list.php?smenu=b';"></div>
<div class="aleft bleft w100"><input type="button" class="w100 text11 <?=$send_imgc?>" value="친구추천 <?=$memo_friend_count2?>" onclick="window.location.href='<?=$member_skin_path?>/member_list.php?smenu=c';"></div>

</div>


<div class="cc fs" style="height:2px;background-color:#990000;"></div>

<form name=fmemberlist method=post>
<input type=hidden name=sst  value='<?=$sst?>'>
<input type=hidden name=sod  value='<?=$sod?>'>
<input type=hidden name=sfl  value='<?=$sfl?>'>
<input type=hidden name=stx  value='<?=$stx?>'>
<input type=hidden name=page value='<?=$page?>'>
<input type=hidden name=receiver id=receiver value='' />

<?

for ($i=0; $row=sql_fetch_array($result); $i++) {
  $k = $i + 1;
$sql2 = "select mb_id from $g4[login_table] where mb_id='$row[mb_id]'";
$resultm = sql_fetch($sql2);
$datetime_all = substr($row['mb_today_login'],2,2).".".substr($row['mb_today_login'],5,2).".".substr($row['mb_today_login'],8,2)." (".get_yoil($row[mb_today_login]).") ".substr($row[mb_today_login],11,5); //날짜표시
if($resultm[mb_id])
{
  $member_online ="<span class='date'>|</span><span class='fontb text11'>접속중</span>";
 }
else
{
  $member_online = "<span class='date'>|</span><span class='text11 fonts'>최근접속 ".$datetime_all."</span>";
 }

// 접근가능한 그룹수
    $sql2 = " select count(*) as cnt from $g4[group_member_table] where mb_id = '$row[mb_id]' ";
    $row2 = sql_fetch($sql2);
    $group = "";
    if ($row2[cnt])
        $group = "<a href='$g4[admin_path]/boardgroupmember_form.php?mb_id=$row[mb_id]'>$row2[cnt]</a>";
$leave_date = $row[mb_leave_date] ? $row[mb_leave_date] : date("Ymd", $g4[server_time]);
    $intercept_date = $row[mb_intercept_date] ? $row[mb_intercept_date] : date("Ymd", $g4[server_time]);
    $mb_name = get_sideview($row[mb_id], $row[mb_name], $row[mb_email], $row[mb_homepage]);

//회원사진출력
$icon_file2 = $g4[path]."/data/profile.img/".$row[mb_id];
if (file_exists($icon_file2)) {
$meicon = "<img src=".$icon_file2." align=absmiddle width=50 height=50>";
}else{
$meicon = "<img src='".$g4[path]."/img/noprofile.png' align=absmiddle width=50 height=50>";
}
    $list = $i%2;
    echo "
<input type=hidden name=mb_id[$i] value='$row[mb_id]'>
<div class='cc downline' style='height:70px;width:650px;' onMouseOver=this.style.backgroundColor='#090909' onMouseOut=this.style.backgroundColor=''>
<div class='cc fs h10'></div>
<div class='cc aleft w40 bcenter'><input type=checkbox name=chk_$i id=chk_$i value=$row[mb_id] class='stop14' onclick='receiver_listing()'></div>
<div class='aleft bleft h50 w70'>".$meicon."</div>
<div class='bleft aleft w400 h50 lh50'>".$mb_name." (".$row[mb_id].")".$member_online."</div>
<div class='aright bcenter lh48' style='width:55px;'>".memo_friend($member[mb_id], $row[mb_id], $row[mb_name], $qstr)."</div>
<div class='cc fs h10'></div>
</div>";
}

if ($i == 0)
echo "<div class='cc bcenter' style='height:300px;line-height:300px;'></a>목록이 없습니다.</div>";

$pagelist = get_paging($config[cf_write_pages], $page, $total_page, "?smenu=$smenu&page=");
echo "<div class='h10 cc fs'></div><div class='page'>".$pagelist."</div>";
?>

<div class="h10 cc fs"></div>
<div class="cc bcenter"><input type=button value="전체" class="btnr h26 w60" onclick='check_all()' style="border-right:1px solid #800000;"><input type="button" value="선택한 친구 쪽지보내기" class="btnr h26 w200" onclick='msg_all()' /><input type="button" onclick="JavaScript:window.close();" value="창닫기" class="btns h26 w150" /></div>
<div class="h20 cc fs"></div>

<?
if ($stx)
    echo "<script language='javascript'>document.fsearch.sfl.value = '$sfl';</script>\n";
?>
</form>


</div>
</center>
<script language="JavaScript">
<!--
function cancel() {
opener.location.reload();
close()
}
//-->

function check_all(){

//모든 체크박스에 체크하기 위한 for문... 체크된건 미체크, 미체크인건 체크함
for(var z=0;z<<?=$rows?>;z++){
if(document.getElementById('chk_'+z)){
if(document.getElementById('chk_'+z).checked){
document.getElementById('chk_'+z).checked=false;
}else{
document.getElementById('chk_'+z).checked=true;
}
}
}

receiver_listing();

}

function receiver_listing(){
var receiver_all='';
var rcv=document.getElementById('receiver');

var s=0;
for(var b=0;b<<?=$rows?>;b++){
var rcvr=document.getElementById('chk_'+b);
if(rcvr){
if(rcvr.checked==true){
if(s=='1'){
receiver_all=receiver_all+","+rcvr.value;
}else{
receiver_all=rcvr.value;
s=1;
}
}
}
}
rcv.value=receiver_all;
}

function msg_all(){

if(document.getElementById('receiver').value==''){
alert('선택된 친구가 없습니다.');
}else{
window.open('/bbs/memo_form.php', 'send_memo', 'scrollbars=yes,toolbars=no,resizable=no,status=no,menubar=no,width=700,height=700');
}

}
</script>
<script language="javascript" src="<?=$g4[path]?>/js/common.js"></script>
<?
 include_once("$g4[path]/tail.sub.php");
?>