0
}
if($searchfor=="proceeding" || $searchfor=="all"){
$inputTable="kasetsart_mod_proceeding";
if($inputSearchKey=="" && $inputTable==""){
$inputTable=$myModule_Table_Member_Research;
$sql="SELECT * FROM ".$inputTable ." ORDER BY ".$inputTable ."_ID DESC";
}else if($inputTable!=""){
$sql="SELECT * FROM ".$inputTable." inner join kasetsart_mod_teacher on (".$inputTable.".".$inputTable."_TeacherID = kasetsart_mod_teacher.kasetsart_mod_teacher_ID)";
if($inputSearchKey!=""){
$sql.=" WHERE ( LOWER(".$inputTable."_NameTh) LIKE '%".strtolower($inputSearchKey)."%' OR LOWER(".$inputTable."_NameTh) LIKE '%".strtolower($inputSearchKey)."%' ";
$sql.=" OR LOWER(".$inputTable."_Owner) LIKE '%".$inputSearchKey."%' OR LOWER(".$inputTable."_TopicTh) LIKE '%".$inputSearchKey."%' ";
$sql.=" OR LOWER(".$inputTable."_TopicEng) LIKE '%".$inputSearchKey."%' OR LOWER(kasetsart_mod_teacher_NameEn) LIKE '%".$inputSearchKey."%') AND kasetsart_mod_teacher_ID=".$inputTable."_TeacherID";
}
$sql.=" ORDER BY ".$inputTable ."_ID DESC";
}
//echo $sql;
$Query=MYSQL_DB_QUERY($System_DataBase_Name,$sql) OR DIE("
0
}
if($searchfor=="presentation" || $searchfor=="all"){
$inputTable="kasetsart_mod_presentation";
if($inputSearchKey=="" && $inputTable==""){
$inputTable=$myModule_Table_Member_Research;
$sql="SELECT * FROM ".$inputTable ." ORDER BY ".$inputTable ."_ID DESC";
}else if($inputTable!=""){
$sql="SELECT * FROM ".$inputTable." inner join kasetsart_mod_teacher on (".$inputTable.".".$inputTable."_TeacherID = kasetsart_mod_teacher.kasetsart_mod_teacher_ID)";
if($inputSearchKey!=""){
$sql.=" WHERE (LOWER(".$inputTable."_NameTh) LIKE '%".$inputSearchKey."%' OR LOWER(".$inputTable."_NameEng) LIKE '%".$inputSearchKey."%' ";
$sql.=" OR LOWER(".$inputTable."_Owner) LIKE '%".$inputSearchKey."%' OR LOWER(".$inputTable."_TopicTh) LIKE '%".$inputSearchKey."%' OR LOWER(".$inputTable."_TopicEn) LIKE '%".$inputSearchKey."%' OR LOWER(kasetsart_mod_teacher_NameEn) LIKE '%".$inputSearchKey."%') AND kasetsart_mod_teacher_ID=".$inputTable."_TeacherID";
}
$sql.=" ORDER BY ".$inputTable ."_ID DESC";
}
//echo $sql;
$Query=MYSQL_DB_QUERY($System_DataBase_Name,$sql) OR DIE("
0
}
if($searchfor=="journal" || $searchfor=="all"){
$inputTable="kasetsart_mod_journal";
if($inputSearchKey=="" && $inputTable==""){
$inputTable=$myModule_Table_Member_Research;
$sql="SELECT * FROM ".$inputTable ." ORDER BY ".$inputTable ."_ID DESC";
}else if($inputTable!=""){
$sql="SELECT * FROM ".$inputTable." inner join kasetsart_mod_teacher on (".$inputTable.".".$inputTable."_TeacherID = kasetsart_mod_teacher.kasetsart_mod_teacher_ID)";
if($inputSearchKey!=""){
$sql.=" WHERE (LOWER(".$inputTable."_NameTh) LIKE '%".$inputSearchKey."%' OR LOWER(".$inputTable."_NameEng) LIKE '%".strtolower($inputSearchKey)."%' ";
$sql.=" OR LOWER(".$inputTable."_Owner) LIKE '%".$inputSearchKey."%' OR LOWER(".$inputTable."_Press) LIKE '%".$inputSearchKey."%' OR LOWER(kasetsart_mod_teacher_NameEn) LIKE '%".$inputSearchKey."%') AND kasetsart_mod_teacher_ID=".$inputTable."_TeacherID";
}
$sql.=" ORDER BY ".$inputTable ."_ID DESC";
}
$Query=MYSQL_DB_QUERY($System_DataBase_Name,$sql) OR DIE("
0
}
if($searchfor=="book" || $searchfor=="all"){
$inputTable="kasetsart_mod_book";
if($inputSearchKey=="" && $inputTable==""){
$inputTable=$myModule_Table_Member_Research;
$sql="SELECT * FROM ".$inputTable ." ORDER BY ".$inputTable ."_ID DESC";
}else if($inputTable!=""){
$sql="SELECT * FROM ".$inputTable." inner join kasetsart_mod_teacher on (".$inputTable.".".$inputTable."_TeacherID = kasetsart_mod_teacher.kasetsart_mod_teacher_ID)";
if($inputSearchKey!=""){
$sql.=" WHERE (LOWER(".$inputTable."_NameTh) LIKE '%".$inputSearchKey."%' OR LOWER(".$inputTable."_NameEng) LIKE '%".$inputSearchKey."%' ";
$sql.=" OR LOWER(".$inputTable."_Owner) LIKE '%".$inputSearchKey."%' OR LOWER(".$inputTable."_Type) LIKE '%".$inputSearchKey."%' OR LOWER(kasetsart_mod_teacher_NameEn) LIKE '%".$inputSearchKey."%') AND kasetsart_mod_teacher_ID=".$inputTable."_TeacherID";
}
$sql.=" ORDER BY ".$inputTable ."_ID DESC";
}
$Query=MYSQL_DB_QUERY($System_DataBase_Name,$sql) OR DIE("
0
}
if($searchfor=="working" || $searchfor=="all"){
$inputTable="kasetsart_mod_working";
if($inputSearchKey=="" && $inputTable==""){
$inputTable=$myModule_Table_Member_Research;
$sql="SELECT * FROM ".$inputTable ." ORDER BY ".$inputTable ."_ID DESC";
}else if($inputTable!=""){
$sql="SELECT * FROM ".$inputTable." inner join kasetsart_mod_teacher on (".$inputTable.".".$inputTable."_TeacherID = kasetsart_mod_teacher.kasetsart_mod_teacher_ID)";
if($inputSearchKey!=""){
$sql.=" WHERE (LOWER(".$inputTable."_NameTh) LIKE '%".$inputSearchKey."%' OR LOWER(".$inputTable."_NameEng) LIKE '%".$inputSearchKey."%' ";
$sql.=" OR LOWER(".$inputTable."_Owner) LIKE '%".$inputSearchKey."%' OR LOWER(".$inputTable."_Abstact) LIKE '%".$inputSearchKey."%' OR LOWER(kasetsart_mod_teacher_NameEn) LIKE '%".$inputSearchKey."%') AND kasetsart_mod_teacher_ID=".$inputTable."_TeacherID";
}
$sql.=" ORDER BY ".$inputTable ."_ID DESC";
}
$Query=MYSQL_DB_QUERY($System_DataBase_Name,$sql) OR DIE("
