생년월일이 표시가안됩니다.ㅠㅠ 정보
생년월일이 표시가안됩니다.ㅠㅠ본문
[회원통합스킨] 신규가입회원 출력모듈 스킨을 다운받아 사용할려고하는데요
다른정보는 추출이 되는데 생년월일이 추출이 안되네요.
-------------------------------------------------------------------
<?
include_once("./_common.php");
include_once("./_common.php");
$new_member_rows = 10;
$sql_common = " from $g4[member_table] ";
$sql_search = " where (1) and mb_id <> '$config[cf_admin]' ";
//if ($is_admin == 'group') $sql_search .= " and mb_level = '$member[mb_level]' ";
if (!isset($sst)) {
$sst = "mb_datetime";
$sod = "desc";
}
$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;
?>
<script language="javascript" src="<?=$g4['path']?>/js/sideview.js"></script>
<table width="310" BORDER=0 CELLPADDING=0 CELLSPACING=0 valign="top">
<tr>
<td>
<table width="290" BORDER=0 align="center" CELLPADDING=0 CELLSPACING=0 valign="top">
<tr>
<td><img src="<?=$g4['path']?>/member_new/up-1_1.gif" width="290" height="9"></td>
</tr>
<tr><td background="<?=$g4['path']?>/member_new/back-up-1_1.gif" width="290" align="center">
<table width=290 align="center" cellpadding=0 cellspacing=0>
<colgroup width=75>
<colgroup width=45>
<colgroup width=50>
<colgroup width=70>
<tr>
<td colspan=2 align=leht> <a href="<?=$g4[bbs_path]?>/register.php"><img src='<?=$g4['path']?>/member_new/join.gif' width=64 height=17 border=0></a></td>
<td align=left colspan=2><span class='small'>최근가입자 <?=$new_member_rows?>명</span></td>
</tr>
<tr>
<td colspan=4><img src='<?=$g4['path']?>/member_new/title_line.gif' align='absmiddle' width=290 border=0></td>
</tr>
<tr>
<td colspan=4 height=3></td>
</tr>
<tr class='bgcol1 bold col1 ht center'>
<td width="73" align=center>이름</td>
<td width="112" align=center>성별</td>
<td width="34" align=center>출생</td>
<td width="71" align=center>가입일</td>
</tr>
<tr>
<td colspan=4 height=3></td>
</tr>
<tr>
<td colspan=4><img src='<?=$g4['path']?>/member_new/title_line.gif' align='absmiddle' width=290 border=0></td>
</tr>
<tr>
<td colspan=4 height=5></td>
</tr>
<?
for ($i=0; $row=sql_fetch_array($result); $i++)
{
$mb_name = get_sideview($row['mb_id'], $row['mb_nick'], $row['mb_email'], $row['mb_homepage']);
$mb_birth = $row['mb_birth'];
$list = $i%2;
$mb_sex = $row['mb_sex'];
if($mb_sex =="M"){
$mb_sex ="<img src='/images/icon_man.gif' align='absmiddle' border=0>";
}else if($mb_sex =="F"){
$mb_sex ="<img src='/images/icon_woman.gif' align='absmiddle' border=0>";
}
echo "
<input type=hidden name=mb_id[$i] value='$row[mb_id]'>
<tr class='list$list col1 ht center'>
<td align=left> $row[mb_name]</td>
<td align=center>$mb_sex</td>
<td align=center>".substr($mb_birth,2,2)."년생</td>
<td align=center>".substr($row['mb_datetime'],2,8)."</td>
?>
<script language="javascript" src="<?=$g4['path']?>/js/sideview.js"></script>
<table width="310" BORDER=0 CELLPADDING=0 CELLSPACING=0 valign="top">
<tr>
<td>
<table width="290" BORDER=0 align="center" CELLPADDING=0 CELLSPACING=0 valign="top">
<tr>
<td><img src="<?=$g4['path']?>/member_new/up-1_1.gif" width="290" height="9"></td>
</tr>
<tr><td background="<?=$g4['path']?>/member_new/back-up-1_1.gif" width="290" align="center">
<table width=290 align="center" cellpadding=0 cellspacing=0>
<colgroup width=75>
<colgroup width=45>
<colgroup width=50>
<colgroup width=70>
<tr>
<td colspan=2 align=leht> <a href="<?=$g4[bbs_path]?>/register.php"><img src='<?=$g4['path']?>/member_new/join.gif' width=64 height=17 border=0></a></td>
<td align=left colspan=2><span class='small'>최근가입자 <?=$new_member_rows?>명</span></td>
</tr>
<tr>
<td colspan=4><img src='<?=$g4['path']?>/member_new/title_line.gif' align='absmiddle' width=290 border=0></td>
</tr>
<tr>
<td colspan=4 height=3></td>
</tr>
<tr class='bgcol1 bold col1 ht center'>
<td width="73" align=center>이름</td>
<td width="112" align=center>성별</td>
<td width="34" align=center>출생</td>
<td width="71" align=center>가입일</td>
</tr>
<tr>
<td colspan=4 height=3></td>
</tr>
<tr>
<td colspan=4><img src='<?=$g4['path']?>/member_new/title_line.gif' align='absmiddle' width=290 border=0></td>
</tr>
<tr>
<td colspan=4 height=5></td>
</tr>
<?
for ($i=0; $row=sql_fetch_array($result); $i++)
{
$mb_name = get_sideview($row['mb_id'], $row['mb_nick'], $row['mb_email'], $row['mb_homepage']);
$mb_birth = $row['mb_birth'];
$list = $i%2;
$mb_sex = $row['mb_sex'];
if($mb_sex =="M"){
$mb_sex ="<img src='/images/icon_man.gif' align='absmiddle' border=0>";
}else if($mb_sex =="F"){
$mb_sex ="<img src='/images/icon_woman.gif' align='absmiddle' border=0>";
}
echo "
<input type=hidden name=mb_id[$i] value='$row[mb_id]'>
<tr class='list$list col1 ht center'>
<td align=left> $row[mb_name]</td>
<td align=center>$mb_sex</td>
<td align=center>".substr($mb_birth,2,2)."년생</td>
<td align=center>".substr($row['mb_datetime'],2,8)."</td>
</tr>";
}
}
if ($i == 0)
echo "<tr><td colspan='$colspan' align=center height=100 class=contentbg>신규회원 없슴.</td></tr>";
?>
<tr>
<td colspan=4 height=5></td>
</tr>
<tr>
<td colspan=4><img src='<?=$g4['path']?>/member_new/title_line.gif' align='absmiddle' width=290 border=0></td>
</tr>
</table>
<tr><td><img src="<?=$g4['path']?>/member_new/end-1_1.gif" width="290" height="8"></td>
</tr>
</table>
</td>
</tr>
<tr height="3"><td></td></tr>
</table>
echo "<tr><td colspan='$colspan' align=center height=100 class=contentbg>신규회원 없슴.</td></tr>";
?>
<tr>
<td colspan=4 height=5></td>
</tr>
<tr>
<td colspan=4><img src='<?=$g4['path']?>/member_new/title_line.gif' align='absmiddle' width=290 border=0></td>
</tr>
</table>
<tr><td><img src="<?=$g4['path']?>/member_new/end-1_1.gif" width="290" height="8"></td>
</tr>
</table>
</td>
</tr>
<tr height="3"><td></td></tr>
</table>
----------------------------------------------------------------------------------------
안되는 이유가 머일까요?ㅠㅠ 꼭좀 알려주세요
댓글 전체
값이 들어있는데 안나오는것인가요?
이상한 값이 나오는것인가요?
<td align=center>".substr($mb_birth,2,2)."년생</td>
윗 부분을 다음처럼 변경해보시고 값이 나오는지부터 확인해보세요.
<td align=center>".$mb_birth."</td>
이상한 값이 나오는것인가요?
<td align=center>".substr($mb_birth,2,2)."년생</td>
윗 부분을 다음처럼 변경해보시고 값이 나오는지부터 확인해보세요.
<td align=center>".$mb_birth."</td>