달력게시판에서 여분필드 사용하기 정보
달력게시판에서 여분필드 사용하기본문
wr_2 여분필드 출력 할수 었어요.....도와주세요....
<?php
include_once($board_skin_path . '/lib/skin.lib.php');
$VAR['today'] = date('Ymd');
$VAR['select'] = date('Ym');
if(preg_match('/^[0-9]{6}$/', $_GET['schedule_ym']) == true && checkdate(substr($_GET['schedule_ym'], 4, 2), 1, substr($_GET['schedule_ym'], 0, 4)) == true) $VAR['select'] = $_GET['schedule_ym'];
$VAR['timestamp'] = strtotime($VAR['select'] . '01');
$VAR['weekday'] = date('w', $VAR['timestamp']);
$VAR['count'] = date('t', $VAR['timestamp']) + $VAR['weekday'] + 1;
$VAR['path'] = "{$g4['bbs_path']}/board.php?bo_table={$bo_table}";
?>
<link rel="stylesheet" type="text/css" href="<?php echo $board_skin_path; ?>/css/list.skin.css" />
<script type="text/javascript" src="<?php echo $board_skin_path; ?>/js/list.skin.js" charset="<?php echo $g4['charset']; ?>"></script>
<center id="G4_LIST" style="width:<?php echo $width; ?>;">
<p class="subject">
<a href="<?php echo phpself('schedule_ym', date('Ym', strtotime('-1 month', $VAR['timestamp']))); ?>"><img src="<?php echo $board_skin_path; ?>/img/b_prev_month.gif" alt="이전달" /></a>
<a href="<?php echo $VAR['path'] . "&schedule_ym={$VAR['select']}"; ?>"><strong><?php echo date('Y년 m월', $VAR['timestamp']); ?></strong></a>
<a href="<?php echo phpself('schedule_ym', date('Ym', strtotime('+1 month', $VAR['timestamp']))); ?>"><img src="<?php echo $board_skin_path; ?>/img/b_next_month.gif" alt="다음달" /></a>
</p>
<table>
<tr>
<td class="sunday"><strong class="white">일</strong></td>
<td class="weekday"><strong class="white">월</strong></td>
<td class="weekday"><strong class="white">화</strong></td>
<td class="weekday"><strong class="white">수</strong></td>
<td class="weekday"><strong class="white">목</strong></td>
<td class="weekday"><strong class="white">금</strong></td>
<td class="saturday"><strong class="white">토</strong></td>
</tr>
<tr>
<?php
for($i = $row = 1; $i < $VAR['count']; $i++, $row++)
{
$date = $i - $VAR['weekday'];
if($date < 1) echo '<td class="default"> </td>';
else
{
$wr_1 = $VAR['select'] . sprintf('%02d', $date);
if($VAR['today'] == $wr_1) $date = "<span style='color:red'>{$date}</span>";
$schedule = null;
$query = sql_query("SELECT wr_id, wr_subject FROM {$write_table} WHERE wr_1 = '{$wr_1}' AND wr_is_comment = 0");
while($result = mysql_fetch_array($query))
{
$schedule .= "<div>
<a href=\"{$VAR['path']}&wr_id={$result['wr_id']}\">{$result['wr_subject']}</a>
<br>{$result[wr_2]}
</div>";
}
if($schedule) $date = "<strong class=\"red\">{$date}</strong>";
echo "<td class=\"default\"><div>{$date}</div>{$schedule}</td>";
}
if($row > 0 && $row % 7 == 0 && $row < $VAR['count']) echo '</tr><tr height="100">';
}
$count = 7 - (($row - 1) % 7);
if($count != 7)
{
for($i = 1; $i <= $count; $i++) echo '<td class="default"> </td>';
}
?>
</tr>
</table>
<?php if($admin_href || !$member['mb_id'] || $write_href){ ?>
<p class="button">
<?php if($write_href) echo "<input type=\"button\" name=\"write\" value=\"添加\" class=\"button\" onclick=\"window.document.location.href='{$write_href}';\" />"; ?>
</p>
<?php } ?>
</center>
<?php
include_once($board_skin_path . '/lib/skin.lib.php');
$VAR['today'] = date('Ymd');
$VAR['select'] = date('Ym');
if(preg_match('/^[0-9]{6}$/', $_GET['schedule_ym']) == true && checkdate(substr($_GET['schedule_ym'], 4, 2), 1, substr($_GET['schedule_ym'], 0, 4)) == true) $VAR['select'] = $_GET['schedule_ym'];
$VAR['timestamp'] = strtotime($VAR['select'] . '01');
$VAR['weekday'] = date('w', $VAR['timestamp']);
$VAR['count'] = date('t', $VAR['timestamp']) + $VAR['weekday'] + 1;
$VAR['path'] = "{$g4['bbs_path']}/board.php?bo_table={$bo_table}";
?>
<link rel="stylesheet" type="text/css" href="<?php echo $board_skin_path; ?>/css/list.skin.css" />
<script type="text/javascript" src="<?php echo $board_skin_path; ?>/js/list.skin.js" charset="<?php echo $g4['charset']; ?>"></script>
<center id="G4_LIST" style="width:<?php echo $width; ?>;">
<p class="subject">
<a href="<?php echo phpself('schedule_ym', date('Ym', strtotime('-1 month', $VAR['timestamp']))); ?>"><img src="<?php echo $board_skin_path; ?>/img/b_prev_month.gif" alt="이전달" /></a>
<a href="<?php echo $VAR['path'] . "&schedule_ym={$VAR['select']}"; ?>"><strong><?php echo date('Y년 m월', $VAR['timestamp']); ?></strong></a>
<a href="<?php echo phpself('schedule_ym', date('Ym', strtotime('+1 month', $VAR['timestamp']))); ?>"><img src="<?php echo $board_skin_path; ?>/img/b_next_month.gif" alt="다음달" /></a>
</p>
<table>
<tr>
<td class="sunday"><strong class="white">일</strong></td>
<td class="weekday"><strong class="white">월</strong></td>
<td class="weekday"><strong class="white">화</strong></td>
<td class="weekday"><strong class="white">수</strong></td>
<td class="weekday"><strong class="white">목</strong></td>
<td class="weekday"><strong class="white">금</strong></td>
<td class="saturday"><strong class="white">토</strong></td>
</tr>
<tr>
<?php
for($i = $row = 1; $i < $VAR['count']; $i++, $row++)
{
$date = $i - $VAR['weekday'];
if($date < 1) echo '<td class="default"> </td>';
else
{
$wr_1 = $VAR['select'] . sprintf('%02d', $date);
if($VAR['today'] == $wr_1) $date = "<span style='color:red'>{$date}</span>";
$schedule = null;
$query = sql_query("SELECT wr_id, wr_subject FROM {$write_table} WHERE wr_1 = '{$wr_1}' AND wr_is_comment = 0");
while($result = mysql_fetch_array($query))
{
$schedule .= "<div>
<a href=\"{$VAR['path']}&wr_id={$result['wr_id']}\">{$result['wr_subject']}</a>
<br>{$result[wr_2]}
</div>";
}
if($schedule) $date = "<strong class=\"red\">{$date}</strong>";
echo "<td class=\"default\"><div>{$date}</div>{$schedule}</td>";
}
if($row > 0 && $row % 7 == 0 && $row < $VAR['count']) echo '</tr><tr height="100">';
}
$count = 7 - (($row - 1) % 7);
if($count != 7)
{
for($i = 1; $i <= $count; $i++) echo '<td class="default"> </td>';
}
?>
</tr>
</table>
<?php if($admin_href || !$member['mb_id'] || $write_href){ ?>
<p class="button">
<?php if($write_href) echo "<input type=\"button\" name=\"write\" value=\"添加\" class=\"button\" onclick=\"window.document.location.href='{$write_href}';\" />"; ?>
</p>
<?php } ?>
</center>
댓글 전체
wr_2를 추출도 하지않고 출력하면 나올리가 없죠
SELECT wr_id, wr_subject FROM <-- 이 부분을 수정하세요
SELECT wr_id, wr_subject, wr_2 FROM
SELECT wr_id, wr_subject FROM <-- 이 부분을 수정하세요
SELECT wr_id, wr_subject, wr_2 FROM