탈퇴한 회원은 목록에 안보이게 하기 질문드립니다. 정보
탈퇴한 회원은 목록에 안보이게 하기 질문드립니다.본문
아래와 같이 하여 별도의 페이지에 회원목록을 보여지게하고 있습니다.
그런데 탈퇴한 회원처리하는게 문제네요...
탈퇴한 회원은 어떻게 해야 걸러질수 있을까요.??
아래 내용은 제가 작업한게 아니라서 자세한 설명을 부탁드립니다.
<table width="740" border="0" cellpadding="3" cellspacing="1" bgcolor="#CCCCCC">
<tr bgcolor="#FFFFFF" height="30">
<td width="35" align="center" height="27"><font color="#1F3D3D">사 진</font></td>
<td width="33" align="center" height="27"><font color="#1F3D3D">성 별</font></td>
<td width="30" align="center" height="27"><font color="#1F3D3D">나 이</font></td>
<td width="120" align="center" height="27"><font color="#1F3D3D">지 역</font></td>
<td width="45" align="center" height="27"><font color="#1F3D3D"> 핸 디</font></td>
<td width="140" align="center" height="27"><font color="#1F3D3D">직 업</font></td>
<td width="432" align="center" height="27"><font color="#1F3D3D">자기소개</font></td>
</tr>
<?
for($i = 0; $row = sql_fetch_array($res); $i++){
$num = $num - 1;
if($row[mb_icon]){
$photo = "../data/member/{$row[mb_id]}/{$row[mb_icon]}";
if(!is_file($photo)){
$photo = "../data/member/noimg/noimg_".rand(0,9).".jpg";
}
}else{
$photo = "../data/member/noimg/noimg_".rand(0,9).".jpg";
}
//echo $photo."<br>";
$tmp_regdate = explode(" ", $row[mb_datetime]);
$days = explode("-", $tmp_regdate[0]);
$times = explode(":", $tmp_regdate[1]);
$new_time = 86400;
$reg_ms = mktime($times[0], $times[1], $times[2], $days[1], $days[2], $days[0]);
if((time() - $reg_ms) <= $new_time){
$new_icon = "<img src='../img/new.gif'>";
} else $new_icon = "";
switch($row[mb_job]){
case "1": $mb_job = "중소기업CEO"; break;
case "2": $mb_job = "대기업임원"; break;
case "3": $mb_job = "대기업직원"; break;
case "4": $mb_job = "회사원"; break;
case "5": $mb_job = "변호사"; break;
case "6": $mb_job = "변리사"; break;
case "7": $mb_job = "세무사"; break;
case "8": $mb_job = "회계사"; break;
case "9": $mb_job = "의사"; break;
case "10": $mb_job = "수의사"; break;
case "11": $mb_job = "치과의사"; break;
case "12": $mb_job = "자영업"; break;
case "13": $mb_job = "교수"; break;
case "14": $mb_job = "공무원"; break;
case "15": $mb_job = "정부투자기관임원"; break;
case "16": $mb_job = "정부투자기관직원"; break;
case "17": $mb_job = "예술인"; break;
case "18": $mb_job = "대중예술인"; break;
case "19": $mb_job = "의류디자이너"; break;
case "20": $mb_job = "인테리어디자이너"; break;
case "21": $mb_job = "교원"; break;
case "22": $mb_job = "대학생"; break;
case "23": $mb_job = "주부"; break;
case "24": $mb_job = "프로골퍼"; break;
case "25": $mb_job = "보험설계사"; break;
case "26": $mb_job = "재무컨설턴트"; break;
case "27": $mb_job = "기타"; break;
}
?>
<tr onClick="location.href='/friend/friend_content.php?idx=<?=$row[mb_no]?>';" style="cursor:hand;" bgcolor="#FFFFFF">
<td width="35" height="30" align="center"><img src="<?=$photo?>" width="35" height="35"></td>
<td width="33" height="30" align="center">
<? if($row[mb_sex] == "M"){ ?>
<img src="../img/icon_m.gif" width="15" height="15">
<? } else if($row[mb_sex] == "F"){ ?>
<img src="../img/icon_f.gif" width="15" height="15">
<? } ?>
</td>
<td width="50" height="30" align="center">
<? if($row[mb_ageType] == "0") { ?>
비공개
<? } else { ?>
<?=$row[mb_age]?>
<? } ?>
</td>
<td width="120" height="30" align="center">
<?=substr($row[mb_addr1], 0, 11)?>
<?=$new_icon?>
</td>
<td width="45" height="30" align="center">
<? if($row[mb_handy] == "1") { ?>
초보
<? } else if($row[mb_handy] == "2") { ?>
1~10
<? } else if($row[mb_handy] == "3"){ ?>
11~20
<? } else if($row[mb_handy] == "4") { ?>
21~30
<? } else if($row[mb_handy] == "5") {?>
31~40
<? } else if($row[mb_handy] == "6") { ?>
41~50
<? } else if($row[mb_handy] == "7" ){ ?>
기타
<? } ?>
</td>
<td width="140" height="30" align="center">
<?=$mb_job?>
</td>
<td width="432" height="30" align="left">
<?=cut_str($row[mb_profile],50,"...");?>
<!--<?=$row[mb_profile]?>-->
</td>
</tr>
<?
}
?>
<? if($i == "0"){ ?>
<tr>
<td align="center" colspan="8" bgcolor="FFFFFF" height="150">회원 정보가 없습니다.</td>
</tr>
<? } ?>
</table>
그런데 탈퇴한 회원처리하는게 문제네요...
탈퇴한 회원은 어떻게 해야 걸러질수 있을까요.??
아래 내용은 제가 작업한게 아니라서 자세한 설명을 부탁드립니다.
<table width="740" border="0" cellpadding="3" cellspacing="1" bgcolor="#CCCCCC">
<tr bgcolor="#FFFFFF" height="30">
<td width="35" align="center" height="27"><font color="#1F3D3D">사 진</font></td>
<td width="33" align="center" height="27"><font color="#1F3D3D">성 별</font></td>
<td width="30" align="center" height="27"><font color="#1F3D3D">나 이</font></td>
<td width="120" align="center" height="27"><font color="#1F3D3D">지 역</font></td>
<td width="45" align="center" height="27"><font color="#1F3D3D"> 핸 디</font></td>
<td width="140" align="center" height="27"><font color="#1F3D3D">직 업</font></td>
<td width="432" align="center" height="27"><font color="#1F3D3D">자기소개</font></td>
</tr>
<?
for($i = 0; $row = sql_fetch_array($res); $i++){
$num = $num - 1;
if($row[mb_icon]){
$photo = "../data/member/{$row[mb_id]}/{$row[mb_icon]}";
if(!is_file($photo)){
$photo = "../data/member/noimg/noimg_".rand(0,9).".jpg";
}
}else{
$photo = "../data/member/noimg/noimg_".rand(0,9).".jpg";
}
//echo $photo."<br>";
$tmp_regdate = explode(" ", $row[mb_datetime]);
$days = explode("-", $tmp_regdate[0]);
$times = explode(":", $tmp_regdate[1]);
$new_time = 86400;
$reg_ms = mktime($times[0], $times[1], $times[2], $days[1], $days[2], $days[0]);
if((time() - $reg_ms) <= $new_time){
$new_icon = "<img src='../img/new.gif'>";
} else $new_icon = "";
switch($row[mb_job]){
case "1": $mb_job = "중소기업CEO"; break;
case "2": $mb_job = "대기업임원"; break;
case "3": $mb_job = "대기업직원"; break;
case "4": $mb_job = "회사원"; break;
case "5": $mb_job = "변호사"; break;
case "6": $mb_job = "변리사"; break;
case "7": $mb_job = "세무사"; break;
case "8": $mb_job = "회계사"; break;
case "9": $mb_job = "의사"; break;
case "10": $mb_job = "수의사"; break;
case "11": $mb_job = "치과의사"; break;
case "12": $mb_job = "자영업"; break;
case "13": $mb_job = "교수"; break;
case "14": $mb_job = "공무원"; break;
case "15": $mb_job = "정부투자기관임원"; break;
case "16": $mb_job = "정부투자기관직원"; break;
case "17": $mb_job = "예술인"; break;
case "18": $mb_job = "대중예술인"; break;
case "19": $mb_job = "의류디자이너"; break;
case "20": $mb_job = "인테리어디자이너"; break;
case "21": $mb_job = "교원"; break;
case "22": $mb_job = "대학생"; break;
case "23": $mb_job = "주부"; break;
case "24": $mb_job = "프로골퍼"; break;
case "25": $mb_job = "보험설계사"; break;
case "26": $mb_job = "재무컨설턴트"; break;
case "27": $mb_job = "기타"; break;
}
?>
<tr onClick="location.href='/friend/friend_content.php?idx=<?=$row[mb_no]?>';" style="cursor:hand;" bgcolor="#FFFFFF">
<td width="35" height="30" align="center"><img src="<?=$photo?>" width="35" height="35"></td>
<td width="33" height="30" align="center">
<? if($row[mb_sex] == "M"){ ?>
<img src="../img/icon_m.gif" width="15" height="15">
<? } else if($row[mb_sex] == "F"){ ?>
<img src="../img/icon_f.gif" width="15" height="15">
<? } ?>
</td>
<td width="50" height="30" align="center">
<? if($row[mb_ageType] == "0") { ?>
비공개
<? } else { ?>
<?=$row[mb_age]?>
<? } ?>
</td>
<td width="120" height="30" align="center">
<?=substr($row[mb_addr1], 0, 11)?>
<?=$new_icon?>
</td>
<td width="45" height="30" align="center">
<? if($row[mb_handy] == "1") { ?>
초보
<? } else if($row[mb_handy] == "2") { ?>
1~10
<? } else if($row[mb_handy] == "3"){ ?>
11~20
<? } else if($row[mb_handy] == "4") { ?>
21~30
<? } else if($row[mb_handy] == "5") {?>
31~40
<? } else if($row[mb_handy] == "6") { ?>
41~50
<? } else if($row[mb_handy] == "7" ){ ?>
기타
<? } ?>
</td>
<td width="140" height="30" align="center">
<?=$mb_job?>
</td>
<td width="432" height="30" align="left">
<?=cut_str($row[mb_profile],50,"...");?>
<!--<?=$row[mb_profile]?>-->
</td>
</tr>
<?
}
?>
<? if($i == "0"){ ?>
<tr>
<td align="center" colspan="8" bgcolor="FFFFFF" height="150">회원 정보가 없습니다.</td>
</tr>
<? } ?>
</table>
댓글 전체
member 테이블에서 탈퇴한 회원이 아닌 사람만 출력하시면 됩니다.
조건은 아마도
SELECT * FROM `g4_member` WHERE mb_leave_date =''
탈퇴한 회원은 mb_leave_date 에 탈퇴한 날짜가 기입 됩니다. 저 조건이면 가능할것 같은데요
조건은 아마도
SELECT * FROM `g4_member` WHERE mb_leave_date =''
탈퇴한 회원은 mb_leave_date 에 탈퇴한 날짜가 기입 됩니다. 저 조건이면 가능할것 같은데요