include("includes/config.php");
include("includes/conn.php");
//$sql_max="select knw_count from tbl_knowledgebase_qns order by knw_count Desc limit 0,3";
//$sql_max_result=mysql_query($sql_max) or die("Query failed : " . mysql_error());
//$row=mysql_fetch_array($sql_max_result);
//$maxi=0;
//while ($sql_row=mysql_fetch_array($sql_max_result,MYSQL_ASSOC))
//{
// $Temp[$maxi]=$sql_row[knw_count];
// $maxi++;
//}
//if ($Temp[0]==$Temp[1]){
// $Temp[1]=$Temp[1]-1;
//}
$sql_knwbase_query = "SELECT * FROM tbl_knowledgebase_qns ORDER BY knw_count DESC limit 0,5";
$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 .="Popular Knowledgebase Topics | Views | ";
$display_knwbase .="
";
while ($sql_knwbase_rows = mysql_fetch_array($sql_knwbase_result, MYSQL_ASSOC)) {
$i++;
$display_knwbase .=" ".$sql_knwbase_rows[knw_qns]." | ".$sql_knwbase_rows[knw_count]." | ";
$display_knwbase .="
";
}
$display_knwbase .="
";
}else{
//$display_knwbase .="