일반회원들이 본인의 추.천.인을 확인하는 페이지를 만들었는데요..
간단하게 자신을 추.천.한 아이디와 회원가입날짜, 기간충전날짜(컨텐츠몰 적용했음)를
나타내야 하거든요..
그런데 아무리해도 기간충전날짜가 안나와서 질문하는 거에여..ㅜㅜ

---------------------------------------------------------------------------------------------------------------

<?
include_once("./_common.php");
include_once("./_head.php");

include_once("$g4[path]/contents.config.php");  // ★

$sql = " select mp_last_date from $g4[cont4_member_period] where mb_id = '$member[mb_id]' ";    // ★
$last_date = sql_fetch($sql);  // ★
$mp_last_date = $last_date[mp_last_date];  // ★


if (!$member[mb_id]) {
alert("회원만!!");
} else {
?>

<style type="text/css">
<!--
.small {font-family:돋움;font-size:8pt;}
.Rnum { font-family:돋움;font-size:8pt;color:coral;font-weight:bold; }
-->
</style>

<?
<b>☞ 추/천/인/보/기</b></a>
if ($mbrecommend) {
$profileRc = get_member("$mbrecommend");
                  }
echo "<table width=100% cellpadding=2 cellspacing=1 border=0 bgcolor=#bbbbbb>";
echo "<tr bgcolor=#dddddd align=center><td width=10><td width=100>아이디
echo "<td width=130>회원가입일<td width=130>기간충전날짜";

if ($mbrecommend == "") { $memberid = $member[mb_id]; } else { $memberid = $mbrecommend; }

$sql = " select
mb_id, mb_name, mb_email, mb_homepage, mb_open, mb_recommend from $g4[member_table]
where mb_recommend = '$memberid' and mb_level >= '2' order by mb_datetime desc ";
$result = sql_query($sql);

if(@mysql_num_rows($result)>0) {

for ($i=0,$j=1; $row=mysql_fetch_array($result); $i++,$j++) {
$tmp_id = $row[mb_id];
$profile = get_member("$tmp_id");

$sqlRnum = "select count(*) as Rnum from $g4[member_table] where mb_recommend = '$tmp_id' and mb_level >= '2'";
$rowRnum = sql_fetch($sqlRnum);

echo "<tr bgcolor=#eeeeee align=center>";
echo "<td class='small'>$j";
echo "<td class='small'>$profile[mb_id]";
echo "<td class='small'>$profile[mb_datetime]";
echo "<td class='small'>                        ";  // ★  위에랑 여기 별표 들어간부분을 어떻게 해야할지 모르겠습니당..ㅜㅜ

} }
echo "</table>";
echo "</div>";

}

include_once("./_tail.php");
?>