전체검색 스킨
select count(*) as cnt from order by ws_id desc
1064 : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order by ws_id desc' at line 4
error file : /adm/website_list.php
오류내용인데 무슨내용인가요?
/adm/website_list.php
이부분이 잘못되었다는 뜻인가요?
해결방법좀...
|
댓글을 작성하시려면 로그인이 필요합니다.
로그인
댓글 6개
select count(*) as cnt from order by ws_id desc
1064 : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order by ws_id desc' at line 4
error file : /adm/website_list.php
오류내용인데 무슨내용인가요?
/adm/website_list.php
이부분이 잘못되었다는 뜻인가요?
해결방법좀...
================================================================================
↑↑↑↑↑↑↑ ↑↑↑↑↑↑↑
07/06/30 00:38 에 작성된 내용을 기준으로 보자면,
즉, 단순히 오류코드만 붙여넣기한 저 상태로는,
죽었다 깨어나도 해결 못합니다.
~from order by~
바른형식 : ~from 테이블명 order by~
오류설명 : 쿼리문에서 테이블명을 불러오는 부분이 빠졌습니다.
질문자가 적절히 알아서 끼워 넣으시면 됩니다.
$sub_menu = "200000ws";
include_once("./_common.php");
$sql_common = " from $g4[site_table] ";
if ($view=="ws_name")
$sql_common .= " where ws_name LIKE '%$stx%' ";
else if ($view=="ws_url")
$sql_common .= " where ws_url LIKE '%$stx%' ";
else if ($view=="ws_memo")
$sql_common .= " where ws_memo LIKE '%$stx%' ";
else if ($view=="ws_level")
$sql_common .= " where ws_level LIKE '%$stx%' ";
else if ($view=="ws_cate")
$sql_common .= " where ws_cate LIKE '%$stx%' ";
else if ($view=="ws_time")
$sql_common .= " where ws_time LIKE '%$stx%' ";
if (!$sst) {
$sst = "ws_id";
$sod = "desc";
}
$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 = 6;
?>
<!--요기다가는 검색폼 넣고-->
<form name=fsearch method=get>
<table width=100% cellpadding=0 cellspacing=0>
<tr>
<td width="100%">
<select id=view name=view>
<option value='ws_name'>사이트명</option>
<option value='ws_url'>주소</option>
<option value='ws_memo'>사이트설명</option>
<option value='ws_cate'>분류</option>
<option value='ws_level'>레벨</option>
<option value='ws_time'>등록일</option>
</select>
<input name=stx size=50 itemname="검색어" required value='<? echo $stx ?>'>
<input type=image src='<?=$g4[admin_path]?>/img/btn_search.gif' align=absmiddle></td>
</tr>
</form>
</table>
<table width=100% cellpadding=0 cellspacing=0>
<tr>
<td colspan='<?=$colspan?>' height='5'></td></tr>
<tr>
<td colspan='<?=$colspan?>' class='line1'></td></tr>
<tr class='bgcol1 bold col1 ht center'>
<td><?=subject_sort_link('ws_name')?>사이트명</a></td>
<td><?=subject_sort_link('ws_url')?>주소</a></td>
<td><?=subject_sort_link('ws_memo')?>사이트설명</a></td>
<td><?=subject_sort_link('ws_time')?>등록일</a></td>
<td><?=subject_sort_link('ws_level')?>레벨</a></td>
<td><a href="./website_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=\"./website_form.php?$qstr&w=u&ws_id=$row[ws_id]\"><img src='img/icon_modify.gif' border=0 title='수정'></a>";
$s_del = "<a href=\"javascript:del('./website_delete.php?$qstr&w=d&ws_id=$row[ws_id]');\"><img src='img/icon_delete.gif' border=0 title='삭제'></a>";
$list = ($i%2);
if ($row[ws_level] == '1') {
$ws_level = "공개";
}
else if ($row[ws_level] == '2') {
$ws_level = "비공개";
}
echo "
<tr class='list$list col1 ht center'>
<td width='100' align='center'><a href='" . set_http($row[ws_url]) . "' target='_blank'><font color=#333333>$row[ws_name]</font></a></td>
<td align=left style='word-break:break-all;'><a href='" . set_http($row[ws_url]) . "' target='_blank'>" . set_http($row[ws_url]) . "</a></td>
<td width='200' align='center'>$row[ws_memo]</td>
<td width='100' align='center'>$row[ws_time]</td>
<td width='40' align='center'>$ws_level</td>
<td width='80' align='center'>{$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, "?view=$view$qstr&page=");
echo "<table width=100% cellpadding=3 cellspacing=1>";
echo "<tr><td width=50% align=right>$pagelist</td></tr></table>\n";
if ($stx)
echo "<script language='javascript'>document.fsearch.stx.value = '$stx';</script>\n";
?>
<?
include_once ("./admin.tail.php");
?>
────────────────
website_list.php 파일 내용입니다...
include_once("./_common.php");
//if (!$stx) alert("검색어가 없습니다.");
$g4[title] = "검색 : " . $stx;
include_once("../_head.php");
if ($stx)
{
//$stx = trim($stx);
$stx = preg_replace("/\//", "\/", trim($stx));
$sop = strtolower($sop);
if (!$sop || !($sop == "and" || $sop == "or")) $sop = "and"; // 연산자 and , or
if (!$srows) $srows = 10; // 한페이지에 출력하는 검색 행수
unset($g4_search[tables]);
unset($g4_search[read_level]);
$sql = " select gr_id, bo_table, bo_read_level
from $g4[board_table]
where bo_use_search = '1'
and bo_list_level <= '$member[mb_level]'
and bo_1 != 'cafe_memo' ";
// and bo_read_level <= '$member[mb_level]' ";
if ($gr_id)
$sql .= " and gr_id = '$gr_id' ";
if ($onetable) // 하나의 게시판만 검색한다면
$sql .= " and bo_table = '$onetable' ";
$sql .= " order by bo_order_search, gr_id, bo_table ";
$result = sql_query($sql);
for ($i=0; $row=sql_fetch_array($result); $i++)
{
if ($is_admin != "super")
{
// 그룹접근 사용에 대한 검색 차단
$sql2 = " select gr_use_access, gr_admin from $g4[group_table] where gr_id = '$row[gr_id]' ";
$row2 = sql_fetch($sql2);
// 그룹접근을 사용한다면
if ($row2[gr_use_access])
{
// 그룹관리자가 있으며 현재 회원이 그룹관리자라면 통과
if ($row2[gr_admin] && $row2[gr_admin] == $member[mb_id])
;
else
{
$sql3 = " select count(*) as cnt from $g4[group_member_table]
where gr_id = '$row[gr_id]'
and mb_id = '$member[mb_id]'
and mb_id <> '' ";
$row3 = sql_fetch($sql3);
if (!$row3[cnt])
continue;
}
}
}
$g4_search[tables][] = $row[bo_table];
$g4_search[read_level][] = $row[bo_read_level];
}
$search_query = "sfl=".urlencode($sfl)."&stx=".urlencode($stx)."&sop=$sop";
$text_stx = get_text(stripslashes($stx));
$op1 = "";
// 검색어를 구분자로 나눈다. 여기서는 공백
$s = explode(" ", $stx);
// 검색필드를 구분자로 나눈다. 여기서는 +
$field = explode("||", trim($sfl));
$str = "(";
for ($i=0; $i<count($s); $i++)
{
//$search_str = strtolower($s[$i]);
$search_str = $s[$i];
$str .= $op1;
$str .= "(";
$op2 = "";
for ($k=0; $k<count($field); $k++) // 필드의 수만큼 다중 필드 검색 가능 (필드1+필드2...)
{
$str .= $op2;
switch ($field[$k])
{
case "mb_id" :
case "mb_name" :
$str .= "$field[$k] = '$s[$i]'";
break;
default :
if (preg_match("/[a-zA-Z]/", $search_str))
$str .= "INSTR(LOWER($field[$k]), LOWER('$search_str'))";
else
$str .= "INSTR($field[$k], '$search_str')";
break;
}
$op2 = " or ";
}
$str .= ")";
$op1 = " $sop ";
// 인기검색어
$sql = " insert into $g4[popular_table]
set pp_word = '$search_str',
pp_date = '$g4[time_ymd]',
pp_ip = '$_SERVER[REMOTE_ADDR]' ";
sql_query($sql, FALSE);
}
$str .= ")";
//$sql_search = $str . " and wr_option not like '%secret%' "; // 비밀글은 제외
$sql_search = $str;
$str_board_list = "";
$board_count = 0;
$time1 = get_microtime();
$total_count = 0;
for ($i=0; $i<count($g4_search[tables]); $i++)
{
$tmp_write_table = $g4[write_prefix] . $g4_search[tables][$i];
$sql = " select wr_id from $tmp_write_table where $sql_search ";
$result = sql_query($sql, false);
$row[cnt] = @mysql_num_rows($result);
//$sql = " select count(*) as cnt from $tmp_write_table where $sql_search ";
//$row = sql_fetch($sql);
$total_count += $row[cnt];
if ($row[cnt])
{
$board_count++;
$search_table[] = $g4_search[tables][$i];
$read_level[] = $g4_search[read_level][$i];
$search_table_count[] = $total_count;
$sql2 = " select bo_subject from $g4[board_table] where bo_table = '{$g4_search[tables][$i]}' ";
$row2 = sql_fetch($sql2);
$str_board_list .= "<a href='$_SERVER[PHP_SELF]?$search_query&gr_id=$gr_id&onetable={$g4_search[tables][$i]}'>$row2[bo_subject]</a>($row[cnt]) ";
}
}
$rows = $srows;
$total_page = ceil($total_count / $rows); // 전체 페이지 계산
if ($page == "") { $page = 1; } // 페이지가 없으면 첫 페이지 (1 페이지)
$from_record = ($page - 1) * $rows; // 시작 열을 구함
for ($i=0; $i<count($search_table); $i++)
{
if ($from_record < $search_table_count[$i])
{
$table_index = $i;
$from_record = $from_record - $search_table_count[$i-1];
break;
}
}
$bo_subject = array();
$list = array();
$k=0;
for ($idx=$table_index; $idx<count($search_table); $idx++)
{
$sql = " select bo_subject from $g4[board_table] where bo_table = '$search_table[$idx]' ";
$row = sql_fetch($sql);
$bo_subject[$idx] = $row[bo_subject];
$tmp_write_table = $g4[write_prefix] . $search_table[$idx];
$sql = " select * from $tmp_write_table where $sql_search order by wr_id desc limit $from_record, $rows ";
$result = sql_query($sql);
for ($i=0; $row=sql_fetch_array($result); $i++)
{
// 검색어까지 링크되면 게시판 부하가 일어남
$list[$idx][$i] = $row;
$list[$idx][$i][href] = "./board.php?bo_table=$search_table[$idx]&wr_id=$row[wr_parent]";
if ($row[wr_is_comment])
{
$link .= "#c{$row[wr_id]}";
$sql2 = " select wr_subject, wr_option from $tmp_write_table where wr_id = '$row[wr_parent]' ";
$row2 = sql_fetch($sql2);
//$row[wr_subject] = $row2[wr_subject];
$row[wr_subject] = get_text($row2[wr_subject]);
}
// 비밀글은 검색 불가
if (strstr($row[wr_option].$row2[wr_option], "secret"))
$row[wr_content] = "[비밀글 입니다.]";
$subject = $row[wr_subject];
if (strstr($sfl, "wr_subject"))
$subject = search_font($stx, $subject);
if ($read_level[$idx] <= $member[mb_level])
{
$content = cut_str(strip_tags($row[wr_content]),300,"…");
if (strstr($sfl, "wr_content"))
$content = search_font($stx, $content);
}
else
$content = '';
$list[$idx][$i][subject] = $subject;
$list[$idx][$i][content] = $content;
$list[$idx][$i][name] = get_sideview($row[mb_id], cut_str($row[wr_name], $config[cf_cut_name]), $row[wr_email], $row[wr_homepage]);
$k++;
if ($k >= $rows)
break;
}
sql_free_result($result);
if ($k >= $rows)
break;
$from_record = 0;
}
$write_pages = get_paging($config[cf_write_pages], $page, $total_page, "$_SERVER[PHP_SELF]?$search_query&gr_id=$gr_id&srows=$srows&onetable=$onetable&page=");
echo "<script language=\"javascript\" src=\"$g4[path]/js/sideview.js\"></script>";
}
$group_select = "<select id='gr_id' name='gr_id' class=select><option value=''>통합검색<option value=''>--------<option value='site_arry'>사이트<option value=''>--------<option value='plus_arry'>플러스<option value=''>--------";
$sql = " select gr_id, gr_subject from $g4[group_table] where gr_1 != 'cafe' order by gr_id ";
$result = sql_query($sql);
for ($i=0; $row=sql_fetch_array($result); $i++)
$group_select .= "<option value='$row[gr_id]'>$row[gr_subject]";
$group_select .= "</select>";
if (!$sfl) $sfl = "wr_subject";
if (!$sop) $sop = "or";
$search_skin_path = "$g4[path]/skin/search/$config[cf_search_skin]";
include_once("$search_skin_path/search.skin.php");
include_once("./_tail.php");
?>
────────────────
여기는 bbs폴더안의 search.php 파일입니다..
여기도 잘못된것이 있져?
오류입니다
select ws_name from where ws_name = 'd' and ws_level = '1' order by ws_heart desc
1064 : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'where ws_name = 'd' and ws_level = '1' order by ws_heart desc' at line 1
error file : /bbs/search.php
설치법대로 하지 않으셔서 발생하는 에러 입니다....
그누보드 기본 소스와는 무관한 에러 입니다.
설치 방법대로 하신후 살펴보시는 것이 좋을듯 합니다...