select count(*) as cnt from g4_member where (1) order by bo_list_level asc
1054 : Unknown column 'bo_list_level' in 'order clause'
error file : /young/access/access.php

위의 쿼리는 테이블의 count를 구하는것인데 count는 정렬이 의미 없는것입니다.
order by bo_list_level asc 를 제거하십시오.

> //if (!$sst) {
> $sst= "a.bo_subject, a.gr_id";
> $sod = "asc";
> //}
위내용 sst가 오류가 나서 주석처리하셨다고 했는데...
어떤오류인지 그것부터 해결하셔야 할것같습니다.

위의 내용이 어떤 항목이 클릭되었는지를 판단해서 소팅을 설정하는것입니다.

아래의 소스 테스트 결과 작동이 됩니다.....

아래것을 교체 해 보세요..

<?
$g4_path = ".";//개인에 맞게 수정
include_once("$g4_path/_common.php");
include_once("$g4[path]/head.sub.php");
$g4[title] = "게시판별 접근권한 안내";
$sql_common = " from $g4[board_table] where (1) and bo_use_search = '1' ";

$sql = " select count(*) as cnt $sql_common";
$row = sql_fetch($sql);
$total_count = $row[cnt];
$sql = " select * $sql_common";
$result = sql_query($sql);
if (!$sst) {
$sst= "bo_subject, gr_id";
$sod = "asc";
}
$sql_order = " order by $sst $sod ";
$sql = " select count(*) as cnt
$sql_common
$sql_order ";
$row = sql_fetch($sql);
$total_count = $row[cnt];
//$rows = $config[cf_page_rows];
$rows = 15;
$total_page= ceil($total_count / $rows);// 전체 페이지 계산
if ($page == "") { $page = 1; } // 페이지가 없으면 첫 페이지 (1 페이지)
$from_record = ($page - 1) * $rows; // 시작 열을 구함
$sql = " select *
$sql_common
$sql_order
limit $from_record, $rows ";
$result = sql_query($sql);
$listall = "<a href='$_SERVER[PHP_SELF]'>처음</a>";
$colspan = 27;
?>
<style>
.tbline1  { border-top: 1px solid #D7D7D7; border-left: 1px solid #D7D7D7; }
.tbline2  { border-right: 1px solid #D7D7D7; border-bottom: 1px solid #D7D7D7; }
</style>
<script language='javascript'>
var list_update_php = '<?=$g4[admin_path]?>/board_list_update.php';
var list_delete_php = '<?=$g4[admin_path]?>/board_list_delete.php';
</script>
<table width="680" cellpadding="5" cellspacing="0">
<tr><td height='30'><?=$g4[title]?></td><td align="right">[게시판수 : <?=number_format($total_count)?>개]</td></tr>
<tr><td height='1' colspan='2' bgcolor="#999999"></td></tr>
</table>
<table width='100%' height='30' cellpadding='0' cellspacing='0' border='0' class=''>
<form name='fsearch' method='get'>
<tr> 
<td width='100%' align='right'><select name='sfl' class='category'>
<option value='bo_admin'> 관리자 </option>
<option value='bo_skin'> 스킨 </option>
<option value='bo_subject'> 제목 </option>
<option value='bo_table' selected> 테이블 </option></select>
<input class='input' type='text' name='stx' size='15' required itemname='검색어' value='<?=$stx?>'>
<input onfocus='blur()' style='cursor:hand;' type='image' src='<?=$g4[admin_path]?>/img/btn_search.gif' align='absmiddle' border=0 title='검색'></td>
</tr></form></table>
<table width="680" cellpadding="0" cellspacing="0" class="tbline1">
<colgroup width='150'>
<colgroup width='50'>
<colgroup width='50'>
<colgroup width='50'>
<colgroup width='50'>
<colgroup width='50'>
<colgroup width='50'>
<colgroup width='50'>
<colgroup width='50'>
<colgroup width='50'>
<? if ($is_admin == "super" || $is_auth) { ?>
<colgroup width='100'>
<colgroup width='60'>
<? } ?>
<tr height='35' align='center' class='subject'>
<td class="tbline2" align='center'><?=subject_sort_link('bo_subject')?>게시판 이름</a></td>
<td class="tbline2" title='목록읽기권한'><?=subject_sort_link('bo_list_level')?>목록</a></td>
<td class="tbline2" title='글읽기권한'><?=subject_sort_link('bo_read_level')?>읽기</a></td>
<td class="tbline2" title='글쓰기권한'><?=subject_sort_link('bo_write_level')?>쓰기</a></td>
<td class="tbline2" title='답변글쓰기권한'><?=subject_sort_link('bo_reply_level')?>답변</a></td>
<td class="tbline2" title='코멘트쓰기권한'><?=subject_sort_link('bo_comment_level')?>덧글</a></td>
<td class="tbline2" title='업로드권한'><?=subject_sort_link('bo_upload_level')?>업</a></td>
<td class="tbline2" title='다운로드권한'><?=subject_sort_link('bo_download_level')?>다운</a></td>
<td class="tbline2" title='HTML쓰기권한'><?=subject_sort_link('bo_html_level')?>HTML</a></td>
<td class="tbline2" title='링크쓰기권한'><?=subject_sort_link('bo_link_level')?>링크</a></td>
<? if ($is_admin == "super" || $is_auth) { ?>
<td class="tbline2" width='100' align='left' style='padding-left:10;'><?=subject_sort_link('bo_skin')?>적용스킨</a></td>
<td class="tbline2" width='60'><a href='<?=$g4[admin_path]?>'>수정</a></td>
<? } ?>
</tr>
<tr><td colspan='12'></td></tr>
<?
for ($i=0; $row=sql_fetch_array($result); $i++) {
//제외게시판 ||(or) 로 구분합다
if($row[bo_table]==aaa||$row[bo_table]==bbb||$row[bo_table]==ccc||$row[bo_table]==fffff){}
if ($is_admin == "super")
$s_upd = "<a href='$g4[admin_path]/board_form.php?w=u&bo_table=$row[bo_table]&$qstr'><img src='$g4[admin_path]/img/icon_modify.gif' border=0 title='수정'></a>";
$list = $i % 2;
$skiname_len = get_text(cut_str($row[bo_skin],15));//나스카님껄로 자르기
echo "
<tr align='center'>
<td style='border-right-width:1;border-right-color:#d7d7d7;border-right-style:solid;border-bottom-width:1;border-bottom-color:#d7d7d7;border-bottom-style:solid;' height=25 title='게시판명' align='left' style='padding-left:10;'><a href='$g4[bbs_path]/board.php?bo_table=$row[bo_table]'>$row[bo_subject]</a></td>
<td style='border-right-width:1;border-right-color:#d7d7d7;border-right-style:solid;border-bottom-width:1;border-bottom-color:#d7d7d7;border-bottom-style:solid;' title='목록보기 권한'>$row[bo_list_level]</td>
<td style='border-right-width:1;border-right-color:#d7d7d7;border-right-style:solid;border-bottom-width:1;border-bottom-color:#d7d7d7;border-bottom-style:solid;' title='글읽기 권한'>$row[bo_read_level]</td>
<td style='border-right-width:1;border-right-color:#d7d7d7;border-right-style:solid;border-bottom-width:1;border-bottom-color:#d7d7d7;border-bottom-style:solid;' title='글쓰기 권한'>$row[bo_write_level]</td>
<td style='border-right-width:1;border-right-color:#d7d7d7;border-right-style:solid;border-bottom-width:1;border-bottom-color:#d7d7d7;border-bottom-style:solid;' title='글답변 권한'>$row[bo_reply_level]</td>
<td style='border-right-width:1;border-right-color:#d7d7d7;border-right-style:solid;border-bottom-width:1;border-bottom-color:#d7d7d7;border-bottom-style:solid;' title='코멘트 쓰기 권한'>$row[bo_comment_level]</td>
<td style='border-right-width:1;border-right-color:#d7d7d7;border-right-style:solid;border-bottom-width:1;border-bottom-color:#d7d7d7;border-bottom-style:solid;' title='업로드 권한'>$row[bo_upload_level]</td>
<td style='border-right-width:1;border-right-color:#d7d7d7;border-right-style:solid;border-bottom-width:1;border-bottom-color:#d7d7d7;border-bottom-style:solid;' title='다운로드 권한'>$row[bo_download_level]</td>
<td style='border-right-width:1;border-right-color:#d7d7d7;border-right-style:solid;border-bottom-width:1;border-bottom-color:#d7d7d7;border-bottom-style:solid;' title='태그사용 권한'>$row[bo_html_level]</td>
<td style='border-right-width:1;border-right-color:#d7d7d7;border-right-style:solid;border-bottom-width:1;border-bottom-color:#d7d7d7;border-bottom-style:solid;' title='링크사용 권한'>$row[bo_link_level]</td>";
if ($is_admin == "super" || $is_auth) {
echo "
<td style='border-right-width:1;border-right-color:#d7d7d7;border-right-style:solid;border-bottom-width:1;border-bottom-color:#d7d7d7;border-bottom-style:solid;' width='100' align='left' style='padding-left:10;'>$skiname_len</td>
<td style='border-right-width:1;border-right-color:#d7d7d7;border-right-style:solid;border-bottom-width:1;border-bottom-color:#d7d7d7;border-bottom-style:solid;' width='60'>$s_upd</td>
</tr>";
} else {
echo "
</tr>";
}
}
if ($i == 0)
echo "<tr><td colspan='12' align='center' height='100' bgcolor='#ffffff'>자료가 없습니다.</td></tr>";
echo "<tr><td colspan='12'></td></tr>";
echo "</table>";
$pagelist = get_paging($config[cf_write_pages], $page, $total_page, "$_SERVER[PHP_SELF]?$qstr&page=");
echo "<table width='100%' height='40' class='' cellpadding=0 cellspacing=0>";
echo "<tr><td width='30%' align='right'>$pagelist&nbsp;&nbsp;</td></tr></table>\n";
if ($stx)
echo "<script>document.fsearch.sfl.value = '$sfl';</script>";
?>
 
<?
include_once("$g4[path]/tail.sub.php");
?>