include("includes/config.php");
include("includes/conn.php");
$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];
}
$sql_knwbase_query = "SELECT * FROM tbl_knowledgebase_qns ORDER BY dept_id ASC";
$sql_knwbase_result = mysql_query($sql_knwbase_query) or die("Query failed : " . mysql_error());
$num_rows = mysql_num_rows($sql_knwbase_result);
$display_knwbase ="";
if ($num_rows > 0){
$display_knwbase .="
";
$display_knwbase .="";
$display_knwbase .="| Categories | ";
$display_knwbase .="
";
$display_knwbase .="";
$display_knwbase .="| | ";
$display_knwbase .="
";
$mytemp = 0;
while ($sql_knwbase_rows = mysql_fetch_array($sql_knwbase_result, MYSQL_ASSOC)) {
if ($mytemp != $sql_knwbase_rows[dept_id]){
$display_knwbase .=" |  | ".$showdepts[$sql_knwbase_rows[dept_id]]." |
";
$mytemp = $sql_knwbase_rows[dept_id];
}
$display_knwbase .="| | | ".$sql_knwbase_rows[knw_qns]." | ";
$display_knwbase .="
";
}
$display_knwbase .="
";
}else{
$display_knwbase .="