금일 생일자를 뽑는 소스인데 잘 안되네요. 정보
금일 생일자를 뽑는 소스인데 잘 안되네요.
본문
팁게시판에서 본 생일자 출력소스를 금일 생일자만 출력하려고 합니다.
또한 금일 생일자가 없는 경우엔 "금일 생일자가 없습니다'라고 출력하고자 하는데요
다음 소스대로 하니, 생일자가 있는데도 없다고 나오네요...
손좀 봐주세요~..
<?
include_once("./_common.php");
?>
include_once("./_common.php");
?>
<?
$today = getdate();
$b_mon = $today['mon'];
$b_day = $today['mday'];
$b_year = $today['year'];
$b_mon = $today['mon'];
$b_day = $today['mday'];
$b_year = $today['year'];
$sql = "select * from $g4[member_table] order by mb_birth";
$result = sql_query($sql);
echo "<table width=190 border=0 cellpadding=0 cellspacing=0 bgcolor=#ffffff><tr>";
echo "<td align=center valign=bottom><b>$b_mon 월$b_day 일</b> 생일자</td></tr>";
echo "<tr><td align=center>";
echo "<font color='#F07F0E'>생일축하합니다.</font>";
echo "</td></tr>";
echo "<tr><td height=1 bgcolor=#ececec></td></tr>";
// echo "<tr><td height=1></td></tr>";
// echo "<tr><td height=2></td></tr>";
echo "<tr><td height=5></td></tr>";
echo "</table>";
echo "<marquee direction=down trueSpeed scrollamount='1' scrolldelay=50 onmouseover='this.stop();' onmouseout='this.start();' height=30><table width=190 border=0 cellpadding=0 cellspacing=0 bgcolor=#ffffff><tr>";
for ($i=0; $row=mysql_fetch_array($result); $i++) {
$birth_month = substr("$row[mb_birth]",-4,2);
$birth_day = substr("$row[mb_birth]",-2,2);
$birth_day = substr("$row[mb_birth]",-2,2);
if (($birth_month == $b_mon)&&($birth_day == $b_day)) {
echo "<tr>";
echo "<td>";
echo "<table border=0 cellpadding=0 cellspacing=0 bgcolor=#ffffff><tr>";
echo "<td width=10></td>";
echo "<td width=8 align=center valign=middle><img src='$g4[path]/birth/images/today_on.gif' border=0></td>";
echo "<td width=100 title=$row[mb_id]> $row[mb_name] 님</td>";
echo "</tr></table>";
echo "</td></tr>";
} else {
echo "<tr>";
echo "<td>";
echo "<table border=0 cellpadding=0 cellspacing=0 bgcolor=#ffffff><tr>";
echo "<td width=10></td>";
echo "<td width=8 align=center valign=middle><img src='$g4[path]/birth/images/today_on.gif' border=0></td>";
echo "<td width=100>금일 생일자는 없습니다.</td>";
echo "</tr></table>";
echo "</td></tr>";
}
}
echo "<tr><td height=5></td></tr>";
echo "</table></marquee>";
?>
echo "<tr>";
echo "<td>";
echo "<table border=0 cellpadding=0 cellspacing=0 bgcolor=#ffffff><tr>";
echo "<td width=10></td>";
echo "<td width=8 align=center valign=middle><img src='$g4[path]/birth/images/today_on.gif' border=0></td>";
echo "<td width=100 title=$row[mb_id]> $row[mb_name] 님</td>";
echo "</tr></table>";
echo "</td></tr>";
} else {
echo "<tr>";
echo "<td>";
echo "<table border=0 cellpadding=0 cellspacing=0 bgcolor=#ffffff><tr>";
echo "<td width=10></td>";
echo "<td width=8 align=center valign=middle><img src='$g4[path]/birth/images/today_on.gif' border=0></td>";
echo "<td width=100>금일 생일자는 없습니다.</td>";
echo "</tr></table>";
echo "</td></tr>";
}
}
echo "<tr><td height=5></td></tr>";
echo "</table></marquee>";
?>
댓글 전체
$today = getdate();
$b_mon = $today['mon'];
$b_day = $today['mday'];
$b_year = $today['year'];
$sql = "select * from $g4[member_table] where substring( mb_birth, 5, 4) = '$b_day$b_mon';
$b_mon = $today['mon'];
$b_day = $today['mday'];
$b_year = $today['year'];
$sql = "select * from $g4[member_table] where substring( mb_birth, 5, 4) = '$b_day$b_mon';
<?
include_once("./_common.php");
?>
<table width="100%" border="0" cellpadding="0" cellspacing="1" bgcolor="DDDDDD">
<tr>
<td>
<table width="100%" border="0" cellpadding="0" cellspacing="4" bgcolor="F5F5F5">
<tr>
<td align="center" valign="top" bgcolor="FFFFFF" style="padding:0px">
<table width=100% border=0 cellpadding=0 cellspacing=0><tr>
<td align=center>
<?
$today = getdate();
$b_mon = $today['mon'];
$b_day = $today['mday'];
$b_year = $today['year'];
$birthday = date("md"); //오늘 날짜(월일)
//회원테이블에서 오늘이 생일인 회원 목록 추출
$sql = " select * from {$g4['member_table']} where substring(mb_birth,5,4) = '{$birthday}' ";
//$sql = "select * from $g4[member_table] order by mb_birth";
$result = sql_query($sql);
echo "<table width=94% border=0 cellpadding=0 cellspacing=0 bgcolor=#ffffff><tr>";
echo "<td align=center valign=bottom><b>$b_mon 월$b_day 일</b> 생일자</td></tr>";
echo "<tr><td align=center bgcolor=#ffffff>";
echo "<font color='#FF6600'>생일축하합니다!.</font>";
echo "</td></tr>";
echo "<tr><td height=1 bgcolor=#ececec></td></tr>";
// echo "<tr><td height=1></td></tr>";
// echo "<tr><td height=2></td></tr>";
echo "<tr><td height=5></td></tr>";
echo "</table>";
echo "<marquee direction=up trueSpeed scrollamount='1' scrolldelay=50 onmouseover='this.stop();' onmouseout='this.start();' height=70 bgcolor=#ffffff><table width=190 border=0 cellpadding=0 cellspacing=0 bgcolor=#ffffff><tr>";
for ($i=0; $row=mysql_fetch_array($result); $i++) {
$birth_month = substr("$row[mb_birth]",-4,2);
$birth_day = substr("$row[mb_birth]",-2,2);
if ($birth_month == $b_mon) {
echo "<tr>";
echo "<td>";
echo "<table border=0 cellpadding=0 cellspacing=0 bgcolor=#ffffff><tr>";
echo "<td width=10></td>";
echo "<td width=8 align=center valign=middle><img src='$g4[path]/include/birth/img/today_on.gif' border=0></td>";
echo "<td width=100 title=$row[mb_id]> $row[mb_nick] 님</td>";
echo "<td> $birth_day 일</td>";
echo "</tr></table>";
echo "</td></tr>";
}
}
echo "<tr><td height=5></td></tr>";
echo "</table></marquee>";
?>
</td></tr>
</table>
</td>
</td></tr>
</table>
</td></tr>
</table>
<table width="100%" cellpadding=0 cellspacing=0>
<tr><td height=5></td></tr>
</table>
include_once("./_common.php");
?>
<table width="100%" border="0" cellpadding="0" cellspacing="1" bgcolor="DDDDDD">
<tr>
<td>
<table width="100%" border="0" cellpadding="0" cellspacing="4" bgcolor="F5F5F5">
<tr>
<td align="center" valign="top" bgcolor="FFFFFF" style="padding:0px">
<table width=100% border=0 cellpadding=0 cellspacing=0><tr>
<td align=center>
<?
$today = getdate();
$b_mon = $today['mon'];
$b_day = $today['mday'];
$b_year = $today['year'];
$birthday = date("md"); //오늘 날짜(월일)
//회원테이블에서 오늘이 생일인 회원 목록 추출
$sql = " select * from {$g4['member_table']} where substring(mb_birth,5,4) = '{$birthday}' ";
//$sql = "select * from $g4[member_table] order by mb_birth";
$result = sql_query($sql);
echo "<table width=94% border=0 cellpadding=0 cellspacing=0 bgcolor=#ffffff><tr>";
echo "<td align=center valign=bottom><b>$b_mon 월$b_day 일</b> 생일자</td></tr>";
echo "<tr><td align=center bgcolor=#ffffff>";
echo "<font color='#FF6600'>생일축하합니다!.</font>";
echo "</td></tr>";
echo "<tr><td height=1 bgcolor=#ececec></td></tr>";
// echo "<tr><td height=1></td></tr>";
// echo "<tr><td height=2></td></tr>";
echo "<tr><td height=5></td></tr>";
echo "</table>";
echo "<marquee direction=up trueSpeed scrollamount='1' scrolldelay=50 onmouseover='this.stop();' onmouseout='this.start();' height=70 bgcolor=#ffffff><table width=190 border=0 cellpadding=0 cellspacing=0 bgcolor=#ffffff><tr>";
for ($i=0; $row=mysql_fetch_array($result); $i++) {
$birth_month = substr("$row[mb_birth]",-4,2);
$birth_day = substr("$row[mb_birth]",-2,2);
if ($birth_month == $b_mon) {
echo "<tr>";
echo "<td>";
echo "<table border=0 cellpadding=0 cellspacing=0 bgcolor=#ffffff><tr>";
echo "<td width=10></td>";
echo "<td width=8 align=center valign=middle><img src='$g4[path]/include/birth/img/today_on.gif' border=0></td>";
echo "<td width=100 title=$row[mb_id]> $row[mb_nick] 님</td>";
echo "<td> $birth_day 일</td>";
echo "</tr></table>";
echo "</td></tr>";
}
}
echo "<tr><td height=5></td></tr>";
echo "</table></marquee>";
?>
</td></tr>
</table>
</td>
</td></tr>
</table>
</td></tr>
</table>
<table width="100%" cellpadding=0 cellspacing=0>
<tr><td height=5></td></tr>
</table>