생년월일이 표시가안됩니다.ㅠㅠ > 그누4 질문답변

그누4 질문답변

그누보드4 관련 질문은 QA 로 이전됩니다. QA 그누보드4 바로가기
기존 게시물은 열람만 가능합니다.

생년월일이 표시가안됩니다.ㅠㅠ 정보

생년월일이 표시가안됩니다.ㅠㅠ

본문

[회원통합스킨] 신규가입회원 출력모듈 스킨을 다운받아 사용할려고하는데요
 
다른정보는 추출이 되는데 생년월일이 추출이 안되네요.
 
-------------------------------------------------------------------
 
<?
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";
}
$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>
    </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>
----------------------------------------------------------------------------------------
 
안되는 이유가 머일까요?ㅠㅠ 꼭좀 알려주세요
  • 복사

댓글 전체

값이 들어있는데 안나오는것인가요?
이상한 값이 나오는것인가요?

<td align=center>".substr($mb_birth,2,2)."년생</td>
윗 부분을 다음처럼 변경해보시고 값이 나오는지부터 확인해보세요.
<td align=center>".$mb_birth."</td>
© SIRSOFT
현재 페이지 제일 처음으로