생일자 마퀴태그 사용해 보기 정보
생일자 마퀴태그 사용해 보기
관련링크
http://zeronara.net/
172회 연결
본문
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>";
?>
추천
0
0
댓글 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>
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>
맞아요 오늘의 생일자만 뽑으려면 좋을것 같은데요
생일