"; if($board=="issues_hboard"){$line_color="green";} ?>
"; //echo mktime(12,0,0,10,27,2003); #########°Ô½Ã¹°ÃѼö############ if(!$find){ $q1="select count(no) from $board where wtype2 is null"; }else{ $sq=" wtype2 is null and "; if($wtype1=="en"){ if($find=="all"){$sq.="en_title like '%$word%' or id like '%$word%' or en_name like '%$word%' or en_contents like '%$word%'";} else if($find=="title"){$sq.="en_title like '%$word%'";} else if($find=="id"){$sq.="id like '%$word%'";} else if($find=="name"){$sq.="en_name like '%$word%'";} else if($find=="contents"){$sq.="en_contents like '%$word%'";} }else{ if($find=="all"){$sq.="n_title like '%$word%' or id like '%$word%' or n_name like '%$word%' or n_contents like '%$word%'";} else if($find=="title"){$sq.="n_title like '%$word%'";} else if($find=="id"){$sq.="id like '%$word%'";} else if($find=="name"){$sq.="n_name like '%$word%'";} else if($find=="contents"){$sq.="n_contents like '%$word%'";} } $q1="select count(no) from $board where ($sq)"; } $total_rows=queryone($q1); //echo "total_row=$total_rows
"; #########°Ô½Ã¹°ÃѼö############ if (!$starts){ $starts=0; $sqc=$total_rows; }else{ $sqc=$total_rows-$starts; } $numbers=10;//ÇÑÆäÀÌÁö´ç °Ô½Ã¹°¼ö if($total_rows) { $cols="rownum as rnum,no,wtype1,en_title,n_title,wdate,wsee,sfilename,ino,id,en_name,n_name,en_contents,n_contents,wtype2"; if(!$find){ $q1="select $cols from (select $cols from $board where wtype2 is null order by no desc) WHERE rnum>$starts and rownum <=$numbers order by ino desc"; }else{ $sq=" wtype2 is null and "; if($wtype1=="en"){ if($find=="all"){$sq.="en_title like '%$word%' or id like '%$word%' or en_name like '%$word%' or en_contents like '%$word%'";} else if($find=="title"){$sq.="en_title like '%$word%'";} else if($find=="id"){$sq.="id like '%$word%'";} else if($find=="name"){$sq.="en_name like '%$word%'";} else if($find=="contents"){$sq.="en_contents like '%$word%'";} }else{ if($find=="all"){$sq.="n_title like '%$word%' or id like '%$word%' or n_name like '%$word%' or n_contents like '%$word%'";} else if($find=="title"){$sq.="n_title like '%$word%'";} else if($find=="id"){$sq.="id like '%$word%'";} else if($find=="name"){$sq.="n_name like '%$word%'";} else if($find=="contents"){$sq.="n_contents like '%$word%'";} } $q1="select $cols from (select $cols from $board where ($sq) order by no desc) WHERE rnum>$starts and rownum <=$numbers and ($sq) order by ino desc"; } //echo "q1=$q1
"; //echo "starts=$starts numbers=$numbers
"; ora_parse($cur,$q1); ora_exec($cur); while(ora_fetch($cur)) { $no=ora_getcolumn($cur,1); $wtype1=ora_getcolumn($cur,2); $wnation=nation($wtype1); $en_title=ora_getcolumn($cur,3); $en_title=cut_str($en_title,50); $n_title=ora_getcolumn($cur,4); $wdate=contime(ora_getcolumn($cur,5),"/"); $wsee=ora_getcolumn($cur,6); $filename=explode("|",ora_getcolumn($cur,7)); $n_contents=ora_getcolumn($cur,13); $file1=explode(".",$filename[0]); if($board!="notice_hboard") { if(trim($n_contents)){$read="nread2.html";} else{$read="nread.html";$wnation="English";} ?> "; } ?>



   0){ for($i=1;$i<=$wstep;$i++){echo "";} } ?>  ";}else{echo $file1[1];}?>
      ";}else{echo $file1[1];}?>
NON DATA