if(!$key|$key=="hboard"){
?>
 |
}else{
?>
 |
}
if(!$where){
echo "
| There isn't the search result
|
";
}
?>
if ($where != ""&&$key!="MEMBER" )
{
//search notice
$tmpWhere = "" ;
$board="oconfer_hboard";
if ($where <> "" ) $tmpWhere ="where $where" ;
$qry="select NO,WTYPE1, EN_TITLE,N_TITLE,WDATE,image1,WSEE from $board $tmpWhere order by NO desc";
//echo("query : $qry ") ;
$result=ora_parse($cur,$qry);
ora_exec($cur);
//$total_row += ora_numrows($cur) ;
while(ora_fetch($cur))
{
$cur_row += 1;
$total_row += 1;
if (($cur_row >= $start_row )&&($cur_row < $last_row )) {
$content_no = ora_getcolumn($cur,0);
$content_type = ora_getcolumn($cur,1);
$content_imgPath = nation($content_type); ;
$content_enTitle = ora_getcolumn($cur,2);
if(strlen($content_enTitle)>50){$content_enTitle=cut_str($content_enTitle,54);}
$content_nTitle = ora_getcolumn($cur,3);
$content_wdate = ora_getcolumn($cur,4);
$content_isAttached =ora_getcolumn($cur,5);
$content_visits = ora_getcolumn($cur,6);
?>
|
=$content_no?>
|
=$content_imgPath?>
|
=$content_enTitle?>
|
=date("Y/m/d",$content_wdate)?>
|
=$content_visits?>
|
"") {?>
O
}?>
|
 |
} //if
} //while
}
if ($where != ""&&$key!="MEMBER" )
{
//PUBLICATION_HBOARD
$tmpWhere = "" ;
$board="PUBLICATION_HBOARD";
if ($where <> "" ) $tmpWhere ="where $where" ;
$qry="select NO,WTYPE1, EN_TITLE,N_TITLE,WDATE,image1,WSEE from $board $tmpWhere order by NO desc";
$result=ora_parse($cur,$qry);
ora_exec($cur);
//$total_row += ora_numrows($cur) ;
while(ora_fetch($cur))
{
$cur_row += 1;
$total_row += 1;
if (($cur_row >= $start_row )&&($cur_row < $last_row )) {
$content_no = ora_getcolumn($cur,0);
$content_type = ora_getcolumn($cur,1);
$content_imgPath = nation($content_type);
$content_enTitle = ora_getcolumn($cur,2);
if(strlen($content_enTitle)>50){$content_enTitle=cut_str($content_enTitle,54);}
$content_nTitle = ora_getcolumn($cur,3);
$content_wdate = ora_getcolumn($cur,4);
$content_isAttached =ora_getcolumn($cur,5);
$content_visits = ora_getcolumn($cur,6);
?>
|
=$content_no?>
|
=$content_imgPath?>
|
=$content_enTitle?>
|
=date("Y/m/d",$content_wdate)?>
|
=$content_visits?>
|
"") {?>
O
}?>
|
 |
}//if
}
}
if ($where != ""&&$key!="MEMBER" )
{
//STATIC_HBOARD
$tmpWhere = "" ;
if ($where <> "" ) $tmpWhere ="where $where" ;
$qry="select NO,WTYPE1, EN_TITLE,N_TITLE,WDATE,image1,WSEE from STATIC_HBOARD $tmpWhere order by NO desc";
$result=ora_parse($cur,$qry);
ora_exec($cur);
$total_row += ora_numrows($cur) ;
while(ora_fetch($cur))
{
$cur_row += 1;
if (($cur_row >= $start_row )&&($cur_row < $last_row)) {
$content_no = ora_getcolumn($cur,0);
$content_type = ora_getcolumn($cur,1);
$content_imgPath = nation($content_type);
$content_enTitle = ora_getcolumn($cur,2);
if(strlen($content_enTitle)>50){$content_enTitle=cut_str($content_enTitle,54);}
$content_nTitle = ora_getcolumn($cur,3);
$content_wdate = ora_getcolumn($cur,4);
$content_isAttached =ora_getcolumn($cur,5);
$content_visits = ora_getcolumn($cur,6);
?>
|
=$content_no?>
|
=$content_imgPath?>
|
=$content_enTitle?>
|
=date("Y/m/d",$content_wdate)?>
|
=$content_visits?>
|
"") {?>
O
}?>
|
 |
}//if
}
}
//SYMPOSIUM_HBOARD
if ($where != ""&&$key!="MEMBER" )
{
$tmpWhere = "" ;
if ($where <> "" ) $tmpWhere ="where $where" ;
$qry="select NO,WTYPE1, EN_TITLE,N_TITLE,WDATE,image1,WSEE from SYMPOSIUM_HBOARD $tmpWhere order by NO desc";
$result=ora_parse($cur,$qry);
ora_exec($cur);
$total_row += ora_numrows($cur) ;
while(ora_fetch($cur))
{
$cur_row += 1;
if (($cur_row >= $start_row )&&($cur_row < $last_row)) {
$content_no = ora_getcolumn($cur,0);
$content_type = ora_getcolumn($cur,1);
$content_imgPath = nation($content_type);
$content_enTitle = ora_getcolumn($cur,2);
if(strlen($content_enTitle)>50){$content_enTitle=cut_str($content_enTitle,54);}
$content_nTitle = ora_getcolumn($cur,3);
$content_wdate = ora_getcolumn($cur,4);
$content_isAttached =ora_getcolumn($cur,5);
$content_visits = ora_getcolumn($cur,6);
?>
|
=$content_no?>
|
=$content_imgPath?>
|
=$content_enTitle?>
|
=date("Y/m/d",$content_wdate)?>
|
=$content_visits?>
|
"") {?>
O
}?>
|
 |
}//if
}//while
}
//DEBATE_HBOARD
if ($where != ""&&$key!="MEMBER" )
{
$tmpWhere = "" ;
if ($where <> "" ) $tmpWhere ="where $where" ;
$qry="select NO,WTYPE1, EN_TITLE,N_TITLE,WDATE,image1,WSEE from DEBATE_HBOARD $tmpWhere order by NO desc";
$result=ora_parse($cur,$qry);
ora_exec($cur);
$total_row += ora_numrows($cur) ;
while(ora_fetch($cur))
{
$cur_row += 1;
if (($cur_row >= $start_row )&&($cur_row < $last_row)) {
$content_no = ora_getcolumn($cur,0);
$content_type = ora_getcolumn($cur,1);
$content_imgPath = nation($content_type);
$content_enTitle = ora_getcolumn($cur,2);
if(strlen($content_enTitle)>50){$content_enTitle=cut_str($content_enTitle,54);}
$content_nTitle = ora_getcolumn($cur,3);
$content_wdate = ora_getcolumn($cur,4);
$content_isAttached =ora_getcolumn($cur,5);
$content_visits = ora_getcolumn($cur,6);
?>
|
=$content_no?>
|
=$content_imgPath?>
|
=$content_enTitle?>
|
=date("Y/m/d",$content_wdate)?>
|
=$content_visits?>
|
"") {?>
O
}?>
|
 |
}//if
}//while
}
//BOOKS_HBOARD
if ($where != ""&&$key!="MEMBER" )
{
$tmpWhere = "" ;
if ($where <> "" ) $tmpWhere ="where $where" ;
$qry="select NO,WTYPE1, EN_TITLE,N_TITLE,WDATE,image1,WSEE from BOOKS_HBOARD $tmpWhere order by NO desc";
$result=ora_parse($cur,$qry);
ora_exec($cur);
$total_row += ora_numrows($cur) ;
while(ora_fetch($cur))
{
$cur_row += 1;
if (($cur_row >= $start_row )&&($cur_row < $last_row)) {
$content_no = ora_getcolumn($cur,0);
$content_type = ora_getcolumn($cur,1);
$content_imgPath = nation($content_type);
$content_enTitle = ora_getcolumn($cur,2);
if(strlen($content_enTitle)>50){$content_enTitle=cut_str($content_enTitle,54);}
$content_nTitle = ora_getcolumn($cur,3);
$content_wdate = ora_getcolumn($cur,4);
$content_isAttached =ora_getcolumn($cur,5);
$content_visits = ora_getcolumn($cur,6);
?>
|
=$content_no?>
|
=$content_imgPath?>
|
=$content_enTitle?>
|
=date("Y/m/d",$content_wdate)?>
|
=$content_visits?>
|
"") {?>
O
}?>
|
 |
}//if
}//while
}
//MEMBER
if ($where != ""&&$key=="MEMBER" )
{
$tmpWhere = "" ;
if ($where <> "" ) $tmpWhere ="where $where" ;
$qry="select NO,ID, EN_NAME,N_NAME,EN_JOB,N_JOB,MAIL,
EN_ORG,N_ORG,EN_OFFICE_AD,N_OFFICE_AD,EN_PART,N_PART,
LANG_MODE,REGDATE,FILE_NAME
FROM MEMBER $tmpWhere ORDER BY NO DESC";
//echo $qry;
$result=ora_parse($cur,$qry);
ora_exec($cur);
$total_row += ora_numrows($cur) ;
while(ora_fetch($cur))
{
$cur_row += 1;
if (($cur_row >= $start_row )&&($cur_row < $last_row)) {
$no = ora_getcolumn($cur,0);
$id = ora_getcolumn($cur,1);
$en_name=ora_getcolumn($cur,2);
$n_name=ora_getcolumn($cur,3);
$en_job=ora_getcolumn($cur,4);
$n_job=ora_getcolumn($cur,5);
$mail=ora_getcolumn($cur,6);
$en_org=ora_getcolumn($cur,7);
$n_org=ora_getcolumn($cur,8);
$en_office_ad=ora_getcolumn($cur,9);
$n_office_ad=ora_getcolumn($cur,10);
$en_part=ora_getcolumn($cur,11);
$n_part=ora_getcolumn($cur,12);
$lang_mode=ora_getcolumn($cur,13);
$regdate=ora_getcolumn($cur,14);
$file_name=ora_getcolumn($cur,15);
?>
|
=$id?>
|
=$en_job?>
|
=$en_org?>
|
=$en_part?>
|
=date("Y/m/d",$regdate)?>
|
=$file_name=($file_name)?"O":"X";?>
|
 |
}//if
}//while
}
?>
|