생일자 마퀴태그 사용해 보기
http://www.sir.co.kr/bbs/tb.php/g4_tiptech/270
여기서 소스 얻고
http://www.blesshome.net/
여기서 힌트를 얻었습니다..
<?
include_once("./_common.php");
?>
<?
$today = getdate();
$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> 생일자</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);
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]/birth/images/today_on.gif' border=0></td>";
echo "<td width=100 title=$row[mb_id]> $row[mb_name] 님</td>";
echo "<td> $birth_day 일</td>";
echo "</tr></table>";
echo "</td></tr>";
}
}
echo "<tr><td height=5></td></tr>";
echo "</table></marquee>";
?>
여기서 소스 얻고
http://www.blesshome.net/
여기서 힌트를 얻었습니다..
<?
include_once("./_common.php");
?>
<?
$today = getdate();
$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> 생일자</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);
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]/birth/images/today_on.gif' border=0></td>";
echo "<td width=100 title=$row[mb_id]> $row[mb_name] 님</td>";
echo "<td> $birth_day 일</td>";
echo "</tr></table>";
echo "</td></tr>";
}
}
echo "<tr><td height=5></td></tr>";
echo "</table></marquee>";
?>
|
댓글을 작성하시려면 로그인이 필요합니다.
로그인
댓글 9개
아무리 꼼수를 부려도 안되네요;;;
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>