회원탈퇴 목록은 안보이게 할 수 없나요?~ 정보
회원탈퇴 목록은 안보이게 할 수 없나요?~
본문
우선 원본 소스 입니다..
<?
include_once("./_common.php");
$new_member_rows = 5;
$sql_common = " from $g4[member_table] ";
//$sql_common = " FROM $g4[member_table] WHERE mb_leave_date ='' ";
$sql_search = " where (1) and mb_id <> '$config[cf_admin]' ";
if (!isset($sst)) {
$sst = "mb_datetime";
$sod = "desc";
}
$sql_order = " order by $sst $sod ";
$sql = " select count(*) as cnt
$sql_common
$sql_search
$sql_order ";
$row = sql_fetch($sql);
$total_count = $row['cnt'];
$sql = " select *
$sql_common
$sql_search
$sql_order
limit $new_member_rows ";
$result = sql_query($sql);
$colspan = 12;
?>
<table width="190">
<?
for ($i=0; $row=sql_fetch_array($result); $i++)
{
$list = $i%2;
echo "
<input type=hidden name=mb_id[$i] value='$row[mb_id]'>
<tr class='list$list col1 ht center'>
<td><font color='#dadada'><a href='http://$row[mb_id].wc.to'>$row[mb_id].wc.to</a></td>
</tr>";
}
if ($i == 0)
echo "<tr><td colspan='$colspan' align=center height=100 class=contentbg>신규회원 없슴.</td></tr>";
?>
</table>
////////////////////////////////
SELECT * FROM `g4_member` WHERE mb_leave_date ='' 을 적용하여 걸러내면 될듯 한데..
mysql 계속 에러가 뜨네요..
어떤 방법으로 적용해야 할까요..
<?
include_once("./_common.php");
$new_member_rows = 5;
$sql_common = " from $g4[member_table] ";
//$sql_common = " FROM $g4[member_table] WHERE mb_leave_date ='' ";
$sql_search = " where (1) and mb_id <> '$config[cf_admin]' ";
if (!isset($sst)) {
$sst = "mb_datetime";
$sod = "desc";
}
$sql_order = " order by $sst $sod ";
$sql = " select count(*) as cnt
$sql_common
$sql_search
$sql_order ";
$row = sql_fetch($sql);
$total_count = $row['cnt'];
$sql = " select *
$sql_common
$sql_search
$sql_order
limit $new_member_rows ";
$result = sql_query($sql);
$colspan = 12;
?>
<table width="190">
<?
for ($i=0; $row=sql_fetch_array($result); $i++)
{
$list = $i%2;
echo "
<input type=hidden name=mb_id[$i] value='$row[mb_id]'>
<tr class='list$list col1 ht center'>
<td><font color='#dadada'><a href='http://$row[mb_id].wc.to'>$row[mb_id].wc.to</a></td>
</tr>";
}
if ($i == 0)
echo "<tr><td colspan='$colspan' align=center height=100 class=contentbg>신규회원 없슴.</td></tr>";
?>
</table>
////////////////////////////////
SELECT * FROM `g4_member` WHERE mb_leave_date ='' 을 적용하여 걸러내면 될듯 한데..
mysql 계속 에러가 뜨네요..
어떤 방법으로 적용해야 할까요..
댓글 전체