= '가' AND title < '나' )) "; }else if($find == 'ㄴ'){ $query.= "(title RLIKE '^ㄴ' OR ( title >= '나' AND title < '다' )) "; }else if($find == 'ㄷ'){ $query.= "(title RLIKE '^(ㄷ|ㄸ)' OR ( title >= '다' AND title < '라' )) "; }else if($find == 'ㄹ'){ $query.= "(title RLIKE '^ㄹ' OR ( title >= '라' AND title < '마' )) "; }else if($find == 'ㅁ'){ $query.= "(title RLIKE '^ㅁ' OR ( title >= '마' AND title < '바' )) "; }else if($find == 'ㅂ'){ $query.= "(title RLIKE '^ㅂ' OR ( title >= '바' AND title < '사' )) "; }else if($find == 'ㅅ'){ $query.= "(title RLIKE '^(ㅅ|ㅆ)' OR ( title >= '사' AND title < '아' )) "; }else if($find == 'ㅇ'){ $query.= "(title RLIKE '^ㅇ' OR ( title >= '아' AND title < '자' )) "; }else if($find == 'ㅈ'){ $query.= "(title RLIKE '^(ㅈ|ㅉ)' OR ( title >= '자' AND title < '차' )) "; }else if($find == 'ㅊ'){ $query.= "(title RLIKE '^ㅊ' OR ( title >= '차' AND title < '카' )) "; }else if($find == 'ㅋ'){ $query.= "(title RLIKE '^ㅋ' OR ( title >= '카' AND title < '타' )) "; }else if($find == 'ㅌ'){ $query.= "(title RLIKE '^ㅌ' OR ( title >= '타' AND title < '파' )) "; }else if($find == 'ㅍ'){ $query.= "(title RLIKE '^ㅍ' OR ( title >= '파' AND title < '하' )) "; }else if($find == 'ㅎ'){ $query.= "(title RLIKE '^ㅎ' OR ( title >= '하')) "; }else{ //영문 초성일경우 $query.= "title LIKE '$find%'"; } } //echo $query."
"; $result = mysql_query($query, $connect); $res = mysql_fetch_array($result); $t_count=$res[COUNT]; $start=($page-1)*$listPerPage; if($t_count%$listPerPage==0){ $lastpage=intval($t_count/$listPerPage); }else{ $lastpage=intval($t_count/$listPerPage)+1; } $query = "SELECT * \n"; $query.= "FROM $table \n"; $query.= "WHERE type=1 AND \n"; if(!$find){ $query.= " $search LIKE '%$searchkey%' \n"; }else{ ///////초성으로 검색하기///////// if($find == 'ㄱ'){ $query.= "(title RLIKE '^(ㄱ|ㄲ)' OR ( title >= '가' AND title < '나' ))"; }else if($find == 'ㄴ'){ $query.= "(title RLIKE '^ㄴ' OR ( title >= '나' AND title < '다' ))"; }else if($find == 'ㄷ'){ $query.= "(title RLIKE '^(ㄷ|ㄸ)' OR ( title >= '다' AND title < '라' ))"; }else if($find == 'ㄹ'){ $query.= "(title RLIKE '^ㄹ' OR ( title >= '라' AND title < '마' ))"; }else if($find == 'ㅁ'){ $query.= "(title RLIKE '^ㅁ' OR ( title >= '마' AND title < '바' ))"; }else if($find == 'ㅂ'){ $query.= "(title RLIKE '^ㅂ' OR ( title >= '바' AND title < '사' ))"; }else if($find == 'ㅅ'){ $query.= "(title RLIKE '^(ㅅ|ㅆ)' OR ( title >= '사' AND title < '아' ))"; }else if($find == 'ㅇ'){ $query.= "(title RLIKE '^ㅇ' OR ( title >= '아' AND title < '자' ))"; }else if($find == 'ㅈ'){ $query.= "(title RLIKE '^(ㅈ|ㅉ)' OR ( title >= '자' AND title < '차' ))"; }else if($find == 'ㅊ'){ $query.= "(title RLIKE '^ㅊ' OR ( title >= '차' AND title < '카' ))"; }else if($find == 'ㅋ'){ $query.= "(title RLIKE '^ㅋ' OR ( title >= '카' AND title < '타' ))"; }else if($find == 'ㅌ'){ $query.= "(title RLIKE '^ㅌ' OR ( title >= '타' AND title < '파' ))"; }else if($find == 'ㅍ'){ $query.= "(title RLIKE '^ㅍ' OR ( title >= '파' AND title < '하' ))"; }else if($find == 'ㅎ'){ $query.= "(title RLIKE '^ㅎ' OR ( title >= '하'))"; }else{ //영문 초성일경우 $query.= "title LIKE '$find%'"; } } $query.= " ORDER BY title ASC LIMIT $start,$listPerPage"; //echo $query."
"; $result = mysql_query($query, $connect); $start_no=($listPerPage*($page-1))+1; ?> Untitled Document
"; $result_logo = mysql_query($query, $connect); $res_logo = mysql_fetch_array($result_logo); $logo=$res_logo[logo]; ?>
 
 
 
".chr($i)."  "; } echo "
"; if(!$find){ //초성검색이 없을 경우 for($i=65;$i<91;$i++) { echo "A".chr($i)." "; } echo "
"; }else{ if($find=="ㄱ" || $find=="ㄴ" || $find=="ㄷ" || $find=="ㄹ" || $find=="ㅁ" || $find=="ㅂ" || $find=="ㅅ" || $find=="ㅇ" || $find=="ㅈ" || $find=="ㅊ" || $find=="ㅋ" || $find=="ㅌ" || $find=="ㅍ" || $find=="ㅎ" || $find=="기타"){ //있는데 한글일 경우 echo "
"; }else{ //있으면서 영문일경우 if(strlen($find)==1){ //한글자 초성 선택했을때 for($i=65;$i<91;$i++) { echo "$find".chr($i)."  "; } }else{ //두글자 초성 선택했을때 $first=substr($find,0,1); for($i=65;$i<91;$i++) { echo "$first".chr($i)."  "; } } echo "
"; } } ?>                                           기타  
 
 
 
의 저널이 검색되었습니다.
 
  순번 MEDIA    저널명    원문제공기간 출판사 ISSN 소장처 URL  
조건과 일치하는 저널정보를 찾을 수 없습니다.
      href="" target="_NEW" >    [".trim($list[coverage])."]"; } //해양대학 요청으로 layout변경 **/ ?> LINK  
$lastpage) break; if($i==$page){ ?>