샤

그누보드 통합검색 방법...

PHP 와 MySql 쿼리를 조합하면

쉽고 빠르게 검색할수 있습니다..

일면 UNION 과 UNION ALL


$tot_sql = "select * from g4_board";
$tot_result = sql_query($tot_sql);

for ($i=0; $tot_row=sql_fetch_array($tot_result); $i++) {
 if($i == 0){
  $cnt_sql =$cnt_sql."SELECT count(*) cnt FROM g4_write_{$tot_row[bo_table]} ".$search_qry;
 }else{
  $cnt_sql =$cnt_sql. "UNION ";
  $cnt_sql =$cnt_sql."SELECT count(*) cnt FROM g4_write_{$tot_row[bo_table]} ".$search_qry;
 }

 if($i == 0){
  $write_table =$write_table."SELECT * FROM g4_write_{$tot_row[bo_table]} ".$search_qry;
 }else{
  $write_table =$write_table. "UNION ";
  $write_table =$write_table."SELECT * FROM g4_write_{$tot_row[bo_table]} ".$search_qry;
 }
}

를 응용해서 사용하시면 될듯합니다^^

그누통합검색이 있지만 간단하게 사용할때 좋아요 ㅎㅎ;;

[이 게시물은 관리자님에 의해 2011-10-31 17:27:00 MySQL에서 이동 됨]

댓글 2개

좋은거 같은데, 패스^^;
mysql 5. 대부터 가능한거죠?
댓글을 작성하시려면 로그인이 필요합니다.

프로그램

8,187건
+
제목 글쓴이 날짜 조회
07-10-19 조회 3,465
07-10-19 조회 3,225
07-10-19 조회 3,175
07-10-19 조회 2,877
07-10-19 조회 4,453
07-10-19 조회 5,819
07-10-19 조회 6,100
07-10-19 조회 3,485
07-10-19 조회 4,947
07-10-17 조회 4,599
07-10-17 조회 5,986
07-10-16 조회 4,610
07-10-15 조회 5,573
07-10-13 조회 5,247
07-10-09 조회 4,951
07-10-09 조회 4,285
07-10-09 조회 4,213
07-10-09 조회 4,771
07-10-09 조회 3,537
07-10-09 조회 3,318
07-10-09 조회 6,792
07-10-09 조회 3,944
07-10-09 조회 3,677
07-10-09 조회 3,996
07-10-09 조회 3,370
07-10-09 조회 4,407
07-10-08 조회 1.1만
07-10-05 조회 3,155
07-10-05 조회 4,080
07-10-03 조회 4,193
07-10-03 조회 3,398
07-10-03 조회 4,242
07-10-03 조회 5,262
07-10-03 조회 4,244
07-10-03 조회 3,644
07-10-03 조회 7,332
07-10-03 조회 4,913
07-10-03 조회 7,582
07-10-03 조회 3,679
07-10-03 조회 3,622
07-10-03 조회 3,629
07-10-03 조회 4,663
07-10-03 조회 4,618
07-10-03 조회 3,315
07-10-03 조회 5,176
07-10-03 조회 2,980
07-10-03 조회 2,651
07-10-03 조회 2,699
07-10-03 조회 2,908
07-10-03 조회 2,915
07-10-03 조회 4,732
07-10-02 조회 3,621
07-10-02 조회 3,154
07-10-02 조회 3,490
07-10-02 조회 5,794
07-10-02 조회 3,527
07-10-02 조회 4,152
07-10-02 조회 3,168
07-10-02 조회 4,832
07-10-02 조회 3,077
07-10-02 조회 8,910
07-10-02 조회 4,567
07-10-01 조회 2,532
07-10-01 조회 3,731
07-09-28 조회 4,756
07-09-28 조회 3,628
07-09-27 조회 3,526
07-09-27 조회 4,037
07-09-27 조회 5,079
07-09-27 조회 4,680
07-09-27 조회 3,817
07-09-27 조회 3,228
07-09-27 조회 3,281
07-09-27 조회 3,916
07-09-27 조회 3,252
07-09-15 조회 4,191
07-09-15 조회 2,907
07-09-13 조회 3,426
07-09-13 조회 2,947
07-09-13 조회 3,385
07-09-11 조회 3,620
07-09-09 조회 3,553
07-08-28 조회 3,495
07-08-28 조회 3,370
07-08-23 조회 4,674
07-08-22 조회 2,868
07-08-21 조회 4,654
07-08-21 조회 3,237
07-08-16 조회 6,508
07-08-07 조회 3,415
07-08-04 조회 3,541
07-08-04 조회 2,912
07-08-04 조회 3,322
07-08-04 조회 4,881
07-08-04 조회 2,724
07-08-04 조회 2,931
07-08-01 조회 5,567
07-08-01 조회 4,984
07-07-31 조회 4,446
07-07-31 조회 4,697