list.skin.php 정렬 순서 / 글쓴순서로 바꾸고 싶어요 정보
list.skin.php 정렬 순서 / 글쓴순서로 바꾸고 싶어요본문
lisk.skin.php 에서
현재 특정값에(지정날짜) 따라 정렬이 되는데
글쓴 순서대로 정렬하고 싶습니다.
이런식이에요.
5번 울하찡 2012.05.09~2012.05.11 ########
1번 울하질 2012.05.11~2012.05.13 ########
위의 순서 처럼 2012.05.09 -> 지정날짜 가 빠른순서로 정렬이 되고있습니다.
아래 내용중 어느부분이 위순서로 정렬은 담당하는걸까요?
<?php
sql_query("CREATE TABLE IF NOT EXISTS `{$g4['table_prefix']}expo` (`code` int(11) NOT NULL AUTO_INCREMENT, `field01` int(11) NOT NULL, `field02` varchar(255) NOT NULL, `field03` varchar(255) NOT NULL, `field04` text NOT NULL, `field05` varchar(255) NOT NULL, `bo_table` varchar(255) NOT NULL, `wr_id` int(11) NOT NULL, PRIMARY KEY (`code`), KEY `bo_table` (`bo_table`,`wr_id`)) CHARSET=utf8", false);
$list = array();
$where = "`wr_is_comment` = '0'";
if(!$_GET['sca']) $where .= " AND SUBSTRING(`wr_1`, 1, 6) = '" . date('Ym', $g4['server_time']) . "'";
else if($_GET['sca'] != 'all') $where .= " AND SUBSTRING(`wr_1`, 1, 6) = '{$_GET['sca']}'";
if($_GET['stx']) $where .= " AND INSTR(`wr_subject`, '{$_GET['stx']}') > 0";
$page = max(1, $_GET['page']);
$result = sql_query("SELECT * FROM `{$write_table}` WHERE {$where} ORDER BY `wr_1` ASC, `wr_2` ASC, `wr_num` ASC, `wr_reply` ASC LIMIT " . (($page - 1) * $board['bo_page_rows']) . ", {$board['bo_page_rows']}");
while($row = sql_fetch_array($result)) $list[] = get_list($row, $board, $board_skin_path, $board['bo_subject_len']);
?>
<script type="text/javascript">
//<![CDATA[
function expo_execute(command)
{
if($('#form').find('[name="chk_wr_id[]"]:checked').size() == 0)
{
alert('먼저 게시글을 선택해주세요.');
return false;
}
if(command == 'drop')
{
if(confirm('선택한 게시글을 삭제하시겠습니까?') == true)
{
$('#form').attr('action', '<?php echo $g4['bbs_path']; ?>/delete_all.php');
$('#form').submit();
}
}
else
{
var popup = window.open('', 'popup', 'top=50px, left=50px, width=500, height=550, scrollbars=1');
$('#form').find('[name="sw"]').attr('value', command);
$('#form').attr('target', 'popup');
$('#form').attr('action', '<?php echo $g4['bbs_path']; ?>/move.php');
$('#form').submit();
}
return false;
}
//]]>
</script>
<style type="text/css">
a.subject:link, a.subject:visited, a.subject:active{color:#626262; font-weight:bold; text-decoration:none;}
a.subject:hover{color:#D40A80; font-weight:bold; text-decoration:underline;}
</style>
<table width="<?php echo $width; ?>" border="0" cellpadding="0" cellspacing="0" align="center">
<?php if($is_checkbox || $admin_href || $write_href){ ?>
<tr><td height="10"></td></tr>
<?php } ?>
<tr><td>
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="13" style="border-bottom:1px solid #C9C9C9;"> </td>
<?php for($i = -2; $i < 12; $i++){ ?>
<?php $result = strtotime("{$i} MONTH", strtotime(date('Y-m-01', $g4['server_time']))); ?>
<?php if(date('Ym', $result) == $_GET['sca'] || ($i == 0 && !$_GET['sca'])){ ?>
<td width="53" valign="bottom"><img src="<?php echo $board_skin_path; ?>/img/b_<?php echo date('m', $result); ?>_on.gif"></td>
<?php } else{ ?>
<td width="53" valign="bottom"><a href="<?php echo $g4['bbs_path']; ?>/board.php?bo_table=<?php echo $board['bo_table']; ?>&sca=<?php echo date('Ym', $result); ?>"><img src="<?php echo $board_skin_path; ?>/img/b_<?php echo date('m', $result); ?>_off.gif"></a></td>
<?php } ?>
<?php } ?>
<td width="" style="border-bottom:1px solid #C9C9C9;"> </td>
</tr>
</table>
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr><td style="padding:12px; border-right:1px solid #C9C9C9; border-bottom:1px solid #C9C9C9; border-left:1px solid #C9C9C9;">
<form id="form" method="post">
<input type="hidden" name="bo_table" value="<?php echo $board['bo_table']; ?>">
<input type="hidden" name="sw" value="">
<input type="hidden" name="sca" value="<?php echo $sca; ?>">
<input type="hidden" name="sfl" value="<?php echo $sfl; ?>">
<input type="hidden" name="stx" value="<?php echo $stx; ?>">
<input type="hidden" name="spt" value="<?php echo $spt; ?>">
<input type="hidden" name="sop" value="<?php echo $sop; ?>">
<input type="hidden" name="page" value="<?php echo $page; ?>">
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<?php for($i = 0; $i < count($list); $i++){ ?>
<?php if($i > 0){ ?>
<tr><td height="9" colspan="3"></td></tr>
<tr><td height="1" bgcolor="#D7D7D7" colspan="3"></td></tr>
<tr><td height="12" colspan="3"></td></tr>
<?php } ?>
<tr>
<td width="130" valign="top">
<table width="100%" border="0" cellpadding="4" cellspacing="1" bgcolor="#D7D7D7">
<?php if($list[$i]['file']['0']['view']){; ?>
<tr><td bgcolor="#FFFFFF"><a href="<?php echo $list[$i]['href']; ?>" title="클릭하시면 박람회내용을 자세히 볼 수 있습니다"><img src="<?php echo "{$list[$i]['file']['0']['path']}/{$list[$i]['file']['0']['file']}"; ?>" style="width:120px; border:none;"></a></td></tr>
<?php } else{ ?>
<tr><td bgcolor="#FFFFFF"><a href="<?php echo $list[$i]['href']; ?>" title="클릭하시면 박람회내용을 자세히 볼 수 있습니다"><img src="<?php echo $board_skin_path; ?>/img/p_none.gif" style="border:none;"></a></td></tr>
<?php } ?>
</table>
<?php if($is_checkbox){ ?>
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr><td height="10"></td></tr>
<tr><td align="center"><input type="checkbox" name="chk_wr_id[]" value="<?php echo $list[$i]['wr_id']; ?>" style="width:13px; height:13px;"></td></tr>
</table>
<?php } ?>
</td>
<td width="15"></td>
<td width="" valign="top">
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr height="26">
<td style="padding:0px 5px 0px 5px;"><a href="<?php echo $list[$i]['href']; ?>" class="subject" title="클릭하시면 박람회내용을 자세히 볼 수 있습니다"><?php echo $list[$i]['wr_subject']; ?></a></td>
<td style="padding:0px 5px 0px 5px; color:#D31748; text-align:right;">
<font color="#666666">조회수</font>
<?php echo number_format($list[$i]['wr_hit']); ?>
</td>
</tr>
<tr><td height="1" background="<?php echo $board_skin_path; ?>/img/g_line.gif" colspan="2"></td></tr>
<tr height="26">
<td style="padding:0px 5px 0px 5px; color:#666666;">
<span style="font-size:8pt; font-family:dotum;">전시기간: </span>
<span style="font-size:8pt; font-family:verdana;"><?php echo preg_replace('/([0-9]{4})([0-9]{2})([0-9]{2})/', '\1-\2-\3', $list[$i]['wr_1']); ?> ~ <?php echo preg_replace('/([0-9]{4})([0-9]{2})([0-9]{2})/', '\1-\2-\3', $list[$i]['wr_2']); ?></span>
</td>
<td></td>
</tr>
<?php
$int = 0;
$result = sql_query("SELECT * FROM `{$write_table}` WHERE `wr_parent` = '{$list[$i]['wr_id']}' AND `wr_is_comment` = '1' ORDER BY `wr_1` ASC, `wr_5` ASC");
while($row = mysql_fetch_assoc($result)){
?>
<?php if($int > 0){ ?>
<tr><td height="5" colspan="2"></td></tr>
<?php } ?>
<tr><td height="1" background="<?php echo $board_skin_path; ?>/img/g_line.gif" colspan="2"></td></tr>
<tr><td height="5" colspan="2"></td></tr>
<tr height="20">
<td style="padding:0px 5px 0px 5px; color:#A5A5A5;">
<font color="#333333"><b>행사명:</b></font>
<a href="<?php echo $list[$i]['href']; ?>" class="subject" title="클릭하시면 박람회내용을 자세히 볼 수 있습니다"><?php echo $row['wr_subject']; ?></a>
</td>
<?php if($row['wr_3'] == '아시아나항공'){ ?>
<td style="padding:0px 5px 0px 5px; text-align:right;"><img src="<?php echo $board_skin_path; ?>/img/i_air_asiana.gif"></td>
<?php } else{ ?>
<td style="padding:0px 5px 0px 5px; text-align:right;"><img src="<?php echo $board_skin_path; ?>/img/i_air_korea.gif"></td>
<?php } ?>
</tr>
<tr height="20">
<td style="padding:0px 5px 0px 5px;">
<font color="#333333"><b>출발일:</b></font>
<span style="color:#666666;"><?php echo preg_replace('/([0-9]{4})([0-9]{2})([0-9]{2})/', '\1-\2-\3', $row['wr_1']); ?></span>
</td>
</tr>
<?php
$int++;
}
?>
</table>
</td>
</tr>
<?php } ?>
<?php if(count($list) == 0){ ?>
<tr><td height="300" align="center"><img src="<?php echo $board_skin_path; ?>/img/p_null.gif"></td></tr>
<?php } ?>
</table>
</form>
</td></tr>
</table><br><br>
</td></tr>
<tr><td style="padding:12px 15px 10px 15px; border:5px solid #EBEBEB; text-align:center;">
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td align="left">
<?php if($is_checkbox){ ?>
<img src="<?php echo $board_skin_path; ?>/img/b_delete.gif" onclick="expo_execute('drop');" style="cursor:pointer;">
<img src="<?php echo $board_skin_path; ?>/img/b_copy.gif" onclick="expo_execute('copy');" style="cursor:pointer;">
<img src="<?php echo $board_skin_path; ?>/img/b_move.gif" onclick="expo_execute('move');" style="cursor:pointer;">
<?php } ?>
</td>
<td align="right">
<?php if($admin_href){ ?><a href="<?php echo $admin_href; ?>"><img src="<?php echo $board_skin_path; ?>/img/b_config.gif"></a><?php } ?>
<?php if($is_checkbox){ ?><a href="<?php echo $g4['bbs_path']; ?>/board.php?bo_table=<?php echo $board['bo_table']; ?>&sca=all"><img src="<?php echo $board_skin_path; ?>/img/b_all.gif"></a><?php } ?>
<?php if($write_href){ ?><a href="<?php echo $write_href; ?>"><img src="<?php echo $board_skin_path; ?>/img/b_write.gif"></a><?php } ?>
</td>
</tr>
</table>
</td></tr>
<?php if($write_pages){ ?>
<tr><td height="20"></td></tr>
<tr><td align="center"><?php echo $write_pages; ?></td></tr>
<?php } ?>
</table>
현재 특정값에(지정날짜) 따라 정렬이 되는데
글쓴 순서대로 정렬하고 싶습니다.
이런식이에요.
5번 울하찡 2012.05.09~2012.05.11 ########
1번 울하질 2012.05.11~2012.05.13 ########
위의 순서 처럼 2012.05.09 -> 지정날짜 가 빠른순서로 정렬이 되고있습니다.
아래 내용중 어느부분이 위순서로 정렬은 담당하는걸까요?
<?php
sql_query("CREATE TABLE IF NOT EXISTS `{$g4['table_prefix']}expo` (`code` int(11) NOT NULL AUTO_INCREMENT, `field01` int(11) NOT NULL, `field02` varchar(255) NOT NULL, `field03` varchar(255) NOT NULL, `field04` text NOT NULL, `field05` varchar(255) NOT NULL, `bo_table` varchar(255) NOT NULL, `wr_id` int(11) NOT NULL, PRIMARY KEY (`code`), KEY `bo_table` (`bo_table`,`wr_id`)) CHARSET=utf8", false);
$list = array();
$where = "`wr_is_comment` = '0'";
if(!$_GET['sca']) $where .= " AND SUBSTRING(`wr_1`, 1, 6) = '" . date('Ym', $g4['server_time']) . "'";
else if($_GET['sca'] != 'all') $where .= " AND SUBSTRING(`wr_1`, 1, 6) = '{$_GET['sca']}'";
if($_GET['stx']) $where .= " AND INSTR(`wr_subject`, '{$_GET['stx']}') > 0";
$page = max(1, $_GET['page']);
$result = sql_query("SELECT * FROM `{$write_table}` WHERE {$where} ORDER BY `wr_1` ASC, `wr_2` ASC, `wr_num` ASC, `wr_reply` ASC LIMIT " . (($page - 1) * $board['bo_page_rows']) . ", {$board['bo_page_rows']}");
while($row = sql_fetch_array($result)) $list[] = get_list($row, $board, $board_skin_path, $board['bo_subject_len']);
?>
<script type="text/javascript">
//<![CDATA[
function expo_execute(command)
{
if($('#form').find('[name="chk_wr_id[]"]:checked').size() == 0)
{
alert('먼저 게시글을 선택해주세요.');
return false;
}
if(command == 'drop')
{
if(confirm('선택한 게시글을 삭제하시겠습니까?') == true)
{
$('#form').attr('action', '<?php echo $g4['bbs_path']; ?>/delete_all.php');
$('#form').submit();
}
}
else
{
var popup = window.open('', 'popup', 'top=50px, left=50px, width=500, height=550, scrollbars=1');
$('#form').find('[name="sw"]').attr('value', command);
$('#form').attr('target', 'popup');
$('#form').attr('action', '<?php echo $g4['bbs_path']; ?>/move.php');
$('#form').submit();
}
return false;
}
//]]>
</script>
<style type="text/css">
a.subject:link, a.subject:visited, a.subject:active{color:#626262; font-weight:bold; text-decoration:none;}
a.subject:hover{color:#D40A80; font-weight:bold; text-decoration:underline;}
</style>
<table width="<?php echo $width; ?>" border="0" cellpadding="0" cellspacing="0" align="center">
<?php if($is_checkbox || $admin_href || $write_href){ ?>
<tr><td height="10"></td></tr>
<?php } ?>
<tr><td>
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="13" style="border-bottom:1px solid #C9C9C9;"> </td>
<?php for($i = -2; $i < 12; $i++){ ?>
<?php $result = strtotime("{$i} MONTH", strtotime(date('Y-m-01', $g4['server_time']))); ?>
<?php if(date('Ym', $result) == $_GET['sca'] || ($i == 0 && !$_GET['sca'])){ ?>
<td width="53" valign="bottom"><img src="<?php echo $board_skin_path; ?>/img/b_<?php echo date('m', $result); ?>_on.gif"></td>
<?php } else{ ?>
<td width="53" valign="bottom"><a href="<?php echo $g4['bbs_path']; ?>/board.php?bo_table=<?php echo $board['bo_table']; ?>&sca=<?php echo date('Ym', $result); ?>"><img src="<?php echo $board_skin_path; ?>/img/b_<?php echo date('m', $result); ?>_off.gif"></a></td>
<?php } ?>
<?php } ?>
<td width="" style="border-bottom:1px solid #C9C9C9;"> </td>
</tr>
</table>
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr><td style="padding:12px; border-right:1px solid #C9C9C9; border-bottom:1px solid #C9C9C9; border-left:1px solid #C9C9C9;">
<form id="form" method="post">
<input type="hidden" name="bo_table" value="<?php echo $board['bo_table']; ?>">
<input type="hidden" name="sw" value="">
<input type="hidden" name="sca" value="<?php echo $sca; ?>">
<input type="hidden" name="sfl" value="<?php echo $sfl; ?>">
<input type="hidden" name="stx" value="<?php echo $stx; ?>">
<input type="hidden" name="spt" value="<?php echo $spt; ?>">
<input type="hidden" name="sop" value="<?php echo $sop; ?>">
<input type="hidden" name="page" value="<?php echo $page; ?>">
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<?php for($i = 0; $i < count($list); $i++){ ?>
<?php if($i > 0){ ?>
<tr><td height="9" colspan="3"></td></tr>
<tr><td height="1" bgcolor="#D7D7D7" colspan="3"></td></tr>
<tr><td height="12" colspan="3"></td></tr>
<?php } ?>
<tr>
<td width="130" valign="top">
<table width="100%" border="0" cellpadding="4" cellspacing="1" bgcolor="#D7D7D7">
<?php if($list[$i]['file']['0']['view']){; ?>
<tr><td bgcolor="#FFFFFF"><a href="<?php echo $list[$i]['href']; ?>" title="클릭하시면 박람회내용을 자세히 볼 수 있습니다"><img src="<?php echo "{$list[$i]['file']['0']['path']}/{$list[$i]['file']['0']['file']}"; ?>" style="width:120px; border:none;"></a></td></tr>
<?php } else{ ?>
<tr><td bgcolor="#FFFFFF"><a href="<?php echo $list[$i]['href']; ?>" title="클릭하시면 박람회내용을 자세히 볼 수 있습니다"><img src="<?php echo $board_skin_path; ?>/img/p_none.gif" style="border:none;"></a></td></tr>
<?php } ?>
</table>
<?php if($is_checkbox){ ?>
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr><td height="10"></td></tr>
<tr><td align="center"><input type="checkbox" name="chk_wr_id[]" value="<?php echo $list[$i]['wr_id']; ?>" style="width:13px; height:13px;"></td></tr>
</table>
<?php } ?>
</td>
<td width="15"></td>
<td width="" valign="top">
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr height="26">
<td style="padding:0px 5px 0px 5px;"><a href="<?php echo $list[$i]['href']; ?>" class="subject" title="클릭하시면 박람회내용을 자세히 볼 수 있습니다"><?php echo $list[$i]['wr_subject']; ?></a></td>
<td style="padding:0px 5px 0px 5px; color:#D31748; text-align:right;">
<font color="#666666">조회수</font>
<?php echo number_format($list[$i]['wr_hit']); ?>
</td>
</tr>
<tr><td height="1" background="<?php echo $board_skin_path; ?>/img/g_line.gif" colspan="2"></td></tr>
<tr height="26">
<td style="padding:0px 5px 0px 5px; color:#666666;">
<span style="font-size:8pt; font-family:dotum;">전시기간: </span>
<span style="font-size:8pt; font-family:verdana;"><?php echo preg_replace('/([0-9]{4})([0-9]{2})([0-9]{2})/', '\1-\2-\3', $list[$i]['wr_1']); ?> ~ <?php echo preg_replace('/([0-9]{4})([0-9]{2})([0-9]{2})/', '\1-\2-\3', $list[$i]['wr_2']); ?></span>
</td>
<td></td>
</tr>
<?php
$int = 0;
$result = sql_query("SELECT * FROM `{$write_table}` WHERE `wr_parent` = '{$list[$i]['wr_id']}' AND `wr_is_comment` = '1' ORDER BY `wr_1` ASC, `wr_5` ASC");
while($row = mysql_fetch_assoc($result)){
?>
<?php if($int > 0){ ?>
<tr><td height="5" colspan="2"></td></tr>
<?php } ?>
<tr><td height="1" background="<?php echo $board_skin_path; ?>/img/g_line.gif" colspan="2"></td></tr>
<tr><td height="5" colspan="2"></td></tr>
<tr height="20">
<td style="padding:0px 5px 0px 5px; color:#A5A5A5;">
<font color="#333333"><b>행사명:</b></font>
<a href="<?php echo $list[$i]['href']; ?>" class="subject" title="클릭하시면 박람회내용을 자세히 볼 수 있습니다"><?php echo $row['wr_subject']; ?></a>
</td>
<?php if($row['wr_3'] == '아시아나항공'){ ?>
<td style="padding:0px 5px 0px 5px; text-align:right;"><img src="<?php echo $board_skin_path; ?>/img/i_air_asiana.gif"></td>
<?php } else{ ?>
<td style="padding:0px 5px 0px 5px; text-align:right;"><img src="<?php echo $board_skin_path; ?>/img/i_air_korea.gif"></td>
<?php } ?>
</tr>
<tr height="20">
<td style="padding:0px 5px 0px 5px;">
<font color="#333333"><b>출발일:</b></font>
<span style="color:#666666;"><?php echo preg_replace('/([0-9]{4})([0-9]{2})([0-9]{2})/', '\1-\2-\3', $row['wr_1']); ?></span>
</td>
</tr>
<?php
$int++;
}
?>
</table>
</td>
</tr>
<?php } ?>
<?php if(count($list) == 0){ ?>
<tr><td height="300" align="center"><img src="<?php echo $board_skin_path; ?>/img/p_null.gif"></td></tr>
<?php } ?>
</table>
</form>
</td></tr>
</table><br><br>
</td></tr>
<tr><td style="padding:12px 15px 10px 15px; border:5px solid #EBEBEB; text-align:center;">
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td align="left">
<?php if($is_checkbox){ ?>
<img src="<?php echo $board_skin_path; ?>/img/b_delete.gif" onclick="expo_execute('drop');" style="cursor:pointer;">
<img src="<?php echo $board_skin_path; ?>/img/b_copy.gif" onclick="expo_execute('copy');" style="cursor:pointer;">
<img src="<?php echo $board_skin_path; ?>/img/b_move.gif" onclick="expo_execute('move');" style="cursor:pointer;">
<?php } ?>
</td>
<td align="right">
<?php if($admin_href){ ?><a href="<?php echo $admin_href; ?>"><img src="<?php echo $board_skin_path; ?>/img/b_config.gif"></a><?php } ?>
<?php if($is_checkbox){ ?><a href="<?php echo $g4['bbs_path']; ?>/board.php?bo_table=<?php echo $board['bo_table']; ?>&sca=all"><img src="<?php echo $board_skin_path; ?>/img/b_all.gif"></a><?php } ?>
<?php if($write_href){ ?><a href="<?php echo $write_href; ?>"><img src="<?php echo $board_skin_path; ?>/img/b_write.gif"></a><?php } ?>
</td>
</tr>
</table>
</td></tr>
<?php if($write_pages){ ?>
<tr><td height="20"></td></tr>
<tr><td align="center"><?php echo $write_pages; ?></td></tr>
<?php } ?>
</table>
댓글 전체
흐음?
질문의 의도를 모르겠군요.
코드를 보니까 생성문이 왜인지 모르게 맨위에 있고..
셀렉문이 다중 쓰이는거 같은데..
어디쪽을 수정하고 싶으신건지..
정렬의 경우는 order by문을 수정하시면 될겁니다.
그누보드가 날자 관련 필드가..
datetime이었던가.. 했었던거 같은데..
질문의 의도를 모르겠군요.
코드를 보니까 생성문이 왜인지 모르게 맨위에 있고..
셀렉문이 다중 쓰이는거 같은데..
어디쪽을 수정하고 싶으신건지..
정렬의 경우는 order by문을 수정하시면 될겁니다.
그누보드가 날자 관련 필드가..
datetime이었던가.. 했었던거 같은데..