검색인데 제목만 검색이되네요 > 그누4 질문답변

그누4 질문답변

그누보드4 관련 질문은 QA 로 이전됩니다. QA 그누보드4 바로가기
기존 게시물은 열람만 가능합니다.

검색인데 제목만 검색이되네요 정보

검색인데 제목만 검색이되네요

본문

오류가 나는곳의 주소를 알려주시면 더 빠르고 정확하게 답변 받을 수 있습니다.

오류 주소 : http://economyview.cafe24.com/index.php

$g4['title'] = '';
include_once('../global_head.php');

$sql_common = " reg_yn ='Y' ";

if ($nstx) {
    $sql_search .= "and (title like '%$nstx%') and w " ;
$qstr .="&nstx=$nstx";
}

$sql = " select count(*) as cnt from $g4[news_table] where $sql_common $sql_search ";
$row = sql_fetch($sql);
$total_count = $row[cnt];

$page_cnt = $g4[page_cnt];
$total_page  = ceil($total_count / $page_cnt);
if (!$page) $page = "1";
$from_record = ($page - 1) * $page_cnt;

$sql = " select * from $g4[news_table] where $sql_common $sql_search order by news_num desc limit $from_record, $page_cnt ";
$result = sql_query($sql);
//explain($sql);

$list = array();

$k = "0";
for ($idx=0; $row=sql_fetch_array($result); $idx++) {

$list[$idx] = $row;
$list[$idx][href] = "./view.php";
$list[$idx][num] = $total_count - ($page - 1) * $page_cnt - $k;
$k++;

}

if ($total_count > 1) $news_paging = get_news_paging($g4[paging_cnt], $page, $total_page, $_SERVER[PHP_SELF]."?page=", $qstr);


$news_skin_path = "$g4[path]/skin/news/page/basic";
include_once($news_skin_path."/search.skin.php");



지금 검색하니까 제목만 검색이 되네요 ㅜ.ㅜ
전체 검색 되게 할려며은 어떻게 해야하나요

고수님들 도와주세요 ㅠ.ㅠ
  • 복사

( select a.* , ( select sum(co_count) as co_count from g4_qa_choose where mb_id=a.mb_id and bo_table = 'g4_qa' ) as q_co_count from `g4_write_g4_qa` a where wr_parent = '282329' and wr_8 != '' and wr_is_comment = 1 and CONVERT(wr_7, UNSIGNED) >= 5 group by wr_content having max(wr_7) order by CONVERT(wr_7, UNSIGNED) desc limit 3 )

1055 : Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'sir.a.wr_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

error file : /15sir/bbs/board.php