년도 카테고리좀 도와주실분^^ 정보
년도 카테고리좀 도와주실분^^본문
파일첨부된것처럼 분류가 해당년도가 중복이 안되도록 합쳐야하는데요~~
소스 로는
<table width="<?=$width?>" align="center" cellpadding="0" cellspacing="0" cellpadding=4 class='board_list'>
<? if ($is_checkbox) { ?><col width="40" /><? } ?>
<col width="150" />
<col />
<col width="300" />
<? if ($is_good) { ?><col width="40" /><? } ?>
<? if ($is_nogood) { ?><col width="40" /><? } ?>
<tr align=center bgcolor=96c36f height=30>
<? if ($is_checkbox) { ?><td><input onclick="if (this.checked) all_checked(true); else all_checked(false);" type="checkbox"></td><?}?>
<td style='BORDER-right: #fafff7 1px solid;BORDER-left: #fafff7 1px solid;'><font color=white><b>년도</td><td style='BORDER-right: #fafff7 1px solid;'><font color=white><b>제목</td><td style=BORDER-RIGHT: #d7dec9 1px solid;><font color=white><b>미리보기</td></tr>
<?
for ($i=0; $i<count($list); $i++) {
$bg = $i%2 ? 0 : 1;
$res = sql_query($sql);
while($row = mysql_fetch_array($res)) {
echo "$row['ca_name'] : $row['ca_name']"; // 이 부분은 적당한 포멧으로 바꾸시면 될듯..
}
?>
<tr class="bg<?=$bg?>">
<? if ($is_checkbox) { ?><td class="checkbox" align='center'><input type=checkbox name=chk_wr_id[] value="<?=$list[$i][wr_id]?>"></td><? } ?>
<td class="name" bgcolor=fafff7 align='center' >
<?
echo $nobr_begin;
echo $list[$i][reply];
echo $list[$i][icon_reply];
echo "{$list[$i][ca_name]} ";
if ($list[$i][comment_cnt])
echo " <a href=\"{$list[$i][comment_href]}\"><span class='comment'>{$list[$i][comment_cnt]}</span></a>";
// if ($list[$i]['link']['count']) { echo "[{$list[$i]['link']['count']}]"; }
// if ($list[$i]['file']['count']) { echo "<{$list[$i]['file']['count']}>"; }
echo $nobr_end;
?>
</td>
<td class="subject" align='center' class=rb ><?if($is_admin){?><a href='<?=$list[$i][href]?>'><?=$list[$i][subject]?></a><?}else{?><?=$list[$i][subject]?><?}?></td>
<td class="datetime" align='center' class=rb><?if($list[$i][wr_link1]){?><a href='<?=$list[$i][wr_link1]?>' target='_blank'><img src=/img/btn_dart.gif></a><?}else{?>-<?}?></td>
<? if ($is_good) { ?><td class="good"><?=$list[$i][wr_good]?></td><? } ?>
<? if ($is_nogood) { ?><td class="nogood"><?=$list[$i][wr_nogood]?></td><? } ?>
</tr>
<? } // end for ?>
<? if (count($list) == 0) { echo "<tr><td colspan='$colspan' height=100 align=center>게시물이 없습니다.</td></tr>"; } ?>
</table>
</form>
<div class="board_button">
<div style="float:left;">
<? if ($list_href) { ?>
<a href="<?=$list_href?>"><img src="<?=$board_skin_path?>/img/btn_list.gif" align="absmiddle" border='0'></a>
<? } ?>
<? if ($is_checkbox) { ?>
<a href="javascript:select_delete();"><img src="<?=$board_skin_path?>/img/btn_select_delete.gif" align="absmiddle" border='0'></a>
<a href="javascript:select_copy('copy');"><img src="<?=$board_skin_path?>/img/btn_select_copy.gif" align="absmiddle" border='0'></a>
<a href="javascript:select_copy('move');"><img src="<?=$board_skin_path?>/img/btn_select_move.gif" align="absmiddle" border='0'></a>
<? } ?>
</div>
<div style="float:right;">
<? if ($write_href) { ?><a href="<?=$write_href?>"><img src="<?=$board_skin_path?>/img/btn_write.gif" border='0'></a><? } ?>
</div>
</div>
<!-- 페이지 -->
<div class="board_page">
<? if ($prev_part_href) { echo "<a href='$prev_part_href'><img src='$board_skin_path/img/page_search_prev.gif' border='0' align=absmiddle title='이전검색'></a>"; } ?>
<?
// 기본으로 넘어오는 페이지를 아래와 같이 변환하여 이미지로도 출력할 수 있습니다.
//echo $write_pages;
$write_pages = str_replace("처음", "<img src='$board_skin_path/img/page_begin.gif' border='0' align='absmiddle' title='처음'>", $write_pages);
$write_pages = str_replace("이전", "<img src='$board_skin_path/img/page_prev.gif' border='0' align='absmiddle' title='이전'>", $write_pages);
$write_pages = str_replace("다음", "<img src='$board_skin_path/img/page_next.gif' border='0' align='absmiddle' title='다음'>", $write_pages);
$write_pages = str_replace("맨끝", "<img src='$board_skin_path/img/page_end.gif' border='0' align='absmiddle' title='맨끝'>", $write_pages);
//$write_pages = preg_replace("/<span>([0-9]*)<\/span>/", "$1", $write_pages);
$write_pages = preg_replace("/<b>([0-9]*)<\/b>/", "<b><span style=\"color:#4D6185; font-size:12px; text-decoration:underline;\">$1</span></b>", $write_pages);
?>
<?=$write_pages?>
<? if ($next_part_href) { echo "<a href='$next_part_href'><img src='$board_skin_path/img/page_search_next.gif' border='0' align=absmiddle title='다음검색'></a>"; } ?>
</div>
</td></tr></table>
>>>>>>>>
이렇게까지햇는데
2차배열로 하라고하는데 통모르겟는데 도와주실분^^;;
소스 로는
<table width="<?=$width?>" align="center" cellpadding="0" cellspacing="0" cellpadding=4 class='board_list'>
<? if ($is_checkbox) { ?><col width="40" /><? } ?>
<col width="150" />
<col />
<col width="300" />
<? if ($is_good) { ?><col width="40" /><? } ?>
<? if ($is_nogood) { ?><col width="40" /><? } ?>
<tr align=center bgcolor=96c36f height=30>
<? if ($is_checkbox) { ?><td><input onclick="if (this.checked) all_checked(true); else all_checked(false);" type="checkbox"></td><?}?>
<td style='BORDER-right: #fafff7 1px solid;BORDER-left: #fafff7 1px solid;'><font color=white><b>년도</td><td style='BORDER-right: #fafff7 1px solid;'><font color=white><b>제목</td><td style=BORDER-RIGHT: #d7dec9 1px solid;><font color=white><b>미리보기</td></tr>
<?
for ($i=0; $i<count($list); $i++) {
$bg = $i%2 ? 0 : 1;
$res = sql_query($sql);
while($row = mysql_fetch_array($res)) {
echo "$row['ca_name'] : $row['ca_name']"; // 이 부분은 적당한 포멧으로 바꾸시면 될듯..
}
?>
<tr class="bg<?=$bg?>">
<? if ($is_checkbox) { ?><td class="checkbox" align='center'><input type=checkbox name=chk_wr_id[] value="<?=$list[$i][wr_id]?>"></td><? } ?>
<td class="name" bgcolor=fafff7 align='center' >
<?
echo $nobr_begin;
echo $list[$i][reply];
echo $list[$i][icon_reply];
echo "{$list[$i][ca_name]} ";
if ($list[$i][comment_cnt])
echo " <a href=\"{$list[$i][comment_href]}\"><span class='comment'>{$list[$i][comment_cnt]}</span></a>";
// if ($list[$i]['link']['count']) { echo "[{$list[$i]['link']['count']}]"; }
// if ($list[$i]['file']['count']) { echo "<{$list[$i]['file']['count']}>"; }
echo $nobr_end;
?>
</td>
<td class="subject" align='center' class=rb ><?if($is_admin){?><a href='<?=$list[$i][href]?>'><?=$list[$i][subject]?></a><?}else{?><?=$list[$i][subject]?><?}?></td>
<td class="datetime" align='center' class=rb><?if($list[$i][wr_link1]){?><a href='<?=$list[$i][wr_link1]?>' target='_blank'><img src=/img/btn_dart.gif></a><?}else{?>-<?}?></td>
<? if ($is_good) { ?><td class="good"><?=$list[$i][wr_good]?></td><? } ?>
<? if ($is_nogood) { ?><td class="nogood"><?=$list[$i][wr_nogood]?></td><? } ?>
</tr>
<? } // end for ?>
<? if (count($list) == 0) { echo "<tr><td colspan='$colspan' height=100 align=center>게시물이 없습니다.</td></tr>"; } ?>
</table>
</form>
<div class="board_button">
<div style="float:left;">
<? if ($list_href) { ?>
<a href="<?=$list_href?>"><img src="<?=$board_skin_path?>/img/btn_list.gif" align="absmiddle" border='0'></a>
<? } ?>
<? if ($is_checkbox) { ?>
<a href="javascript:select_delete();"><img src="<?=$board_skin_path?>/img/btn_select_delete.gif" align="absmiddle" border='0'></a>
<a href="javascript:select_copy('copy');"><img src="<?=$board_skin_path?>/img/btn_select_copy.gif" align="absmiddle" border='0'></a>
<a href="javascript:select_copy('move');"><img src="<?=$board_skin_path?>/img/btn_select_move.gif" align="absmiddle" border='0'></a>
<? } ?>
</div>
<div style="float:right;">
<? if ($write_href) { ?><a href="<?=$write_href?>"><img src="<?=$board_skin_path?>/img/btn_write.gif" border='0'></a><? } ?>
</div>
</div>
<!-- 페이지 -->
<div class="board_page">
<? if ($prev_part_href) { echo "<a href='$prev_part_href'><img src='$board_skin_path/img/page_search_prev.gif' border='0' align=absmiddle title='이전검색'></a>"; } ?>
<?
// 기본으로 넘어오는 페이지를 아래와 같이 변환하여 이미지로도 출력할 수 있습니다.
//echo $write_pages;
$write_pages = str_replace("처음", "<img src='$board_skin_path/img/page_begin.gif' border='0' align='absmiddle' title='처음'>", $write_pages);
$write_pages = str_replace("이전", "<img src='$board_skin_path/img/page_prev.gif' border='0' align='absmiddle' title='이전'>", $write_pages);
$write_pages = str_replace("다음", "<img src='$board_skin_path/img/page_next.gif' border='0' align='absmiddle' title='다음'>", $write_pages);
$write_pages = str_replace("맨끝", "<img src='$board_skin_path/img/page_end.gif' border='0' align='absmiddle' title='맨끝'>", $write_pages);
//$write_pages = preg_replace("/<span>([0-9]*)<\/span>/", "$1", $write_pages);
$write_pages = preg_replace("/<b>([0-9]*)<\/b>/", "<b><span style=\"color:#4D6185; font-size:12px; text-decoration:underline;\">$1</span></b>", $write_pages);
?>
<?=$write_pages?>
<? if ($next_part_href) { echo "<a href='$next_part_href'><img src='$board_skin_path/img/page_search_next.gif' border='0' align=absmiddle title='다음검색'></a>"; } ?>
</div>
</td></tr></table>
>>>>>>>>
이렇게까지햇는데
2차배열로 하라고하는데 통모르겟는데 도와주실분^^;;
댓글 전체
이 코드를 활용해 보세요. ^^
<?
$rowspans = array();
$prev_ca = "";
$rowspanid = 0;
$rowspan = 0;
for ($i=0; $i<count($list); $i++) {
if($prev_ca != $list[$i]['ca_name']) { $rowspan = 1; $rowspanid = $i; $prev_ca = $list[$i]['ca_name']; }
else { $rowspan ++; $rowspans[$i] = 0; }
$rowspans[$rowspanid] = $rowspan;
}
?>
<table width=100% align="center" cellpadding="0" cellspacing="0" cellpadding=4>
<col width="150" />
<col />
<col width="300" />
<tr align=center bgcolor=96c36f height=30>
<td style='BORDER-right: #fafff7 1px solid;BORDER-left: #fafff7 1px solid;'><font color=white><b>년도</td>
<td style='BORDER-right: #fafff7 1px solid;'><font color=white><b>제목</td>
<td style=BORDER-RIGHT: #d7dec9 1px solid;><font color=white><b>미리보기</td>
</tr>
<?
for ($i=0; $i<count($list); $i++) {
$bg = $i%2 ? 0 : 1;
?>
<tr class="bg<?=$bg?>">
<? if($rowspans[$i]>0) { ?>
<td class="name" bgcolor=fafff7 align='center' rowspan=<?=$rowspans[$i]?>>
<? echo "{$list[$i]['ca_name']} "; ?>
</td>
<? } ?>
<td class="subject" align='center' class=rb ><?=$list[$i]['subject']?></td>
<td class="datetime" align='center' class=rb><img src=/img/btn_dart.gif></a></td>
</tr>
<? } // end for
?>
</table>
<?
$rowspans = array();
$prev_ca = "";
$rowspanid = 0;
$rowspan = 0;
for ($i=0; $i<count($list); $i++) {
if($prev_ca != $list[$i]['ca_name']) { $rowspan = 1; $rowspanid = $i; $prev_ca = $list[$i]['ca_name']; }
else { $rowspan ++; $rowspans[$i] = 0; }
$rowspans[$rowspanid] = $rowspan;
}
?>
<table width=100% align="center" cellpadding="0" cellspacing="0" cellpadding=4>
<col width="150" />
<col />
<col width="300" />
<tr align=center bgcolor=96c36f height=30>
<td style='BORDER-right: #fafff7 1px solid;BORDER-left: #fafff7 1px solid;'><font color=white><b>년도</td>
<td style='BORDER-right: #fafff7 1px solid;'><font color=white><b>제목</td>
<td style=BORDER-RIGHT: #d7dec9 1px solid;><font color=white><b>미리보기</td>
</tr>
<?
for ($i=0; $i<count($list); $i++) {
$bg = $i%2 ? 0 : 1;
?>
<tr class="bg<?=$bg?>">
<? if($rowspans[$i]>0) { ?>
<td class="name" bgcolor=fafff7 align='center' rowspan=<?=$rowspans[$i]?>>
<? echo "{$list[$i]['ca_name']} "; ?>
</td>
<? } ?>
<td class="subject" align='center' class=rb ><?=$list[$i]['subject']?></td>
<td class="datetime" align='center' class=rb><img src=/img/btn_dart.gif></a></td>
</tr>
<? } // end for
?>
</table>
전진님 짱^^ 너무 감사드립니다^^
완전 잘됨^^ 천재이신듯^^ 짱^^