//include('check_session.php');
include("includes/config.php");
include("includes/conn.php");
if($_POST) {
$sql_getdept_query="SELECT * FROM `tbl_departments` ";
$sql_getdept_result = mysql_query($sql_getdept_query) or die("Query failed : " . mysql_error());
while ($sql_getdept_row = mysql_fetch_array($sql_getdept_result, MYSQL_ASSOC)) {
$showdepts[$sql_getdept_row[dept_id]] = $sql_getdept_row[dept_name];
}
if($keys=="" or $keys==" ") {
if($select!='all')
$str = "SELECT * FROM tbl_knowledgebase_qns dept_id=$select ORDER BY dept_id ASC ";
else
$str = "SELECT * FROM tbl_knowledgebase_qns ORDER BY dept_id ASC ";
}
else {
$keywords = preg_split("/[\s,]/", $keys);
$cnt=count($keywords);
$str = "SELECT * FROM tbl_knowledgebase_qns ";
for($i=0;$i < $cnt;$i++)
{
if($i==0)
$str.=" where knw_qns like '%".$keywords[$i]."%' or knw_ans like '%".$keywords[$i]."%'";
else
$str.=" or knw_qns like '%".$keywords[$i]."%' or knw_ans like '%".$keywords[$i]."%'";
}
if($select!='all'){
//$sql_knwbase_query = "SELECT * FROM tbl_knowledgebase_qns where knw_qns like '%".$keys."%' or knw_ans like '%".$keys."%' ORDER BY dept_id ASC ";
$str.=" ORDER BY dept_id ASC";
}
else {
//$sql_knwbase_query = "SELECT * FROM tbl_knowledgebase_qns where knw_qns like '%".$keys."%' or knw_ans like '%".$keys."%' ORDER BY dept_id ASC ";
$str.=" ORDER BY dept_id ASC";
}
}
//echo "
".$str;
$sql_knwbase_result = mysql_query($str);
$num_rows = mysql_num_rows($sql_knwbase_result);
$display_knwbase ="";
if ($num_rows > 0){
$display_knwbase .="
| Search Result | "; $display_knwbase .=""; $display_knwbase .=" | "; $display_knwbase .=" |
| No Records | "; $display_knwbase .=""; $display_knwbase .=" | "; $display_knwbase .=" |
| ||||||||||||||||||||||||||||||||||||