검색인데 제목만 검색이되네요 정보
검색인데 제목만 검색이되네요본문
오류가 나는곳의 주소를 알려주시면 더 빠르고 정확하게 답변 받을 수 있습니다.
오류 주소 : 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");
지금 검색하니까 제목만 검색이 되네요 ㅜ.ㅜ
전체 검색 되게 할려며은 어떻게 해야하나요
고수님들 도와주세요 ㅠ.ㅠ
오류 주소 : 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