select count(*) as cnt from g4_topschool_category where ca_mb_id = 'redhare' order by ca_id asc

1054 : Unknown column 'ca_mb_id' in 'where clause'

error file : /adm/category_list.php

이렇게 뜨네요 뭐가 문제인가요?

빌더는 탑스쿨 빌더 썼어요




<?
$sub_menu = "900200";
include_once("./_common.php");

auth_check($auth[$sub_menu], "r");

$sql_common = " from $g4[category_table] ";

if ($is_admin != 'super')
    $sql_common .= " where ca_mb_id = '$member[mb_id]' ";

if (!$sst) {
    $sst = "ca_id";
    $sod = "asc";
}

$sql_order = " order by $sst $sod ";

$sql = " select count(*) as cnt
        $sql_common
        $sql_search
        $sql_order ";
$row = sql_fetch($sql);
$total_count = $row[cnt];

$rows = $config[cf_page_rows];
$total_page  = ceil($total_count / $rows);  // 전체 페이지 계산
if (!$page) $page = 1; // 페이지가 없으면 첫 페이지 (1 페이지)
$from_record = ($page - 1) * $rows; // 시작 열을 구함

$listall = "<a href='$_SERVER[PHP_SELF]' class=tt>처음</a>";

$g4[title] = "탑빌더메뉴설정";
include_once("./admin.head.php");

$sql = " select *
          $sql_common
          $sql_search
          $sql_order
          limit $from_record, $rows ";
$result = sql_query($sql);

$colspan = 15;

$qstr = "page=$page";
?>

<script language="javascript" src="<?=$g4[path]?>/js/sideview.js"></script>
<script language="JavaScript">
var list_update_php = "category_list_update.php";
</script>
<div style="width:700px;border:3px solid blue;">
연결주소는 bbs 폴더 기준입니다.<br>
예) /content.php?ct_id=1&cate_id=1010 이렇게 넣었을경우 실제 걸리는 링크주소는<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;/bbs/content.php?ct_id=1&cate_id=1010 가 되는것입니다.<br>
여기서 별도에 파일링크를 잡으실려면 /../test/test.php?cate_id=1010 이렇게 입력하시면<br>
/test/test.php 로 링크가 잡히게 됩니다.
</div>
<form name=fmemberlist method=post>
<input type=hidden name=page value='<?=$page?>'>
<table width=100% cellpadding=0 cellspacing=0>
<colgroup width=30>
<colgroup width=60>
<colgroup width=''>
<colgroup width=160>
<colgroup width=30>
<colgroup width=80>
<tr><td colspan='<?=$colspan?>' class='line1'></td></tr>
<tr class='bgcol1 bold col1 ht center'>
    <td><input type=checkbox name=chkall value='1' onclick='check_all(this.form)'></td>
    <td><?=subject_sort_link('ca_id')?>고유코드</a></td>
    <td><?=subject_sort_link('ca_name')?>카테고리명</a></td>
    <td><?=subject_sort_link('ca_url')?>연결주소</a></td>
    <td><?=subject_sort_link('ca_openchk')?>공개</a></td>
<td><a href="./category_form.php"><img src='<?=$g4[admin_path]?>/img/icon_insert.gif' border=0 title='추가'></a></td>
</tr>
<tr><td colspan='<?=$colspan?>' class='line2'></td></tr>
<?
for ($i=0; $row=sql_fetch_array($result); $i++) {
$s_mod = "<a href=\"./category_form.php?$qstr&w=u&ca_id=$row[ca_id]\"><img src='img/icon_modify.gif' border=0 title='수정'></a>";
$s_del = "<a href=\"javascript:del('./category_form_update.php?$qstr&w=d&ca_id=$row[ca_id]');\"><img src='img/icon_delete.gif' border=0 title='삭제'></a>";
$s_view = "<a href=\"$g4[path]/category_form.php?$qstr&w=u&ca_id=$row[ca_id]\"><img src='img/icon_view.gif' border=0 title='보기'></a>";

$sort = "";
if(strlen($row[ca_id]) <= 2){
$sort .= "└";
}else{
for($k=2 ; $k <= strlen($row[ca_id]); $k++){
$sort .= "&nbsp;&nbsp;";
}
$sort .= "└";
}
/* 리스트 스킨 수정시 사용
$subskin = "";
$subarr = get_skin_dir("submenu");
for ($i=0; $i<count($subarr); $i++) {
$selected = "";
if($ca[ca_skin] == $subarr[$i]){
$selected = "selected";
}
$subskin .= "<option value='$subarr[$i]' $selected>$subarr[$i]</option>\n";
}

$topskin = "";
$toparr = get_skin_dir("topmenu");
for ($i=0; $i<count($toparr); $i++) {
$selected = "";
if($ca[ca_skin] == $toparr[$i]){
$selected = "selected";
}
$topskin .= "<option value='$toparr[$i]' $selected>$toparr[$i]</option>\n";
}
*/
$checked = "";
if($row[ca_openchk] == "y"){
$checked = "checked";
}

    echo "
    <input type=hidden name=ca_id[$i] value='$row[ca_id]'>
    <tr class='list$list col1 ht center'>
        <td><input type=checkbox name=chk[] value='$i'></td>
        <td><nobr style='display:block; overflow:hidden; width:60;'>&nbsp;$row[ca_id]</nobr></td>
        <td align=left><nobr style='display:block; overflow:hidden;'> $sort <input type='text' name='ca_name[$i]' value='$row[ca_name]'></nobr></td>
        <td><nobr style='display:block; overflow:hidden; width:160px;'><input type='text' name='ca_url[$i]' value='$row[ca_url]' style=width:160px;></nobr></td>
        <td><nobr style='display:block; overflow:hidden; width:30px;'><input type='checkbox' name='ca_openchk[$i]' value='y' $checked></nobr></td>
        <td>$s_mod $s_del </td>
    </tr>";
}

if ($i == 0)
    echo "<tr><td colspan='$colspan' align=center height=100 class=contentbg>자료가 없습니다.</td></tr>";

echo "<tr><td colspan='$colspan' class='line2'></td></tr>";
echo "</table>";

$pagelist = get_paging($config[cf_write_pages], $page, $total_page, "?$qstr&page=");
echo "<table width=100% cellpadding=3 cellspacing=1>";
echo "<tr><td width=50%>";
echo "<input type=button class='btn1' value='선택수정' onclick=\"btn_check(this.form, 'update')\">&nbsp;";
echo "</td>";
echo "<td width=50% align=right>$pagelist</td></tr></table>\n";

if ($stx)
    echo "<script language='javascript'>document.fsearch.sfl.value = '$sfl';</script>\n";
?>
</form>

<?
include_once ("./admin.tail.php");
?>