'.$rsContent["ContentSubHeading"].'
';} if(!empty($rsContent["ContentHeading"])){$sHead=$rsContent["ContentHeading"];} if(!empty($rsContent["ContentBrief"])){$sContentBrief=''.$rsContent["ContentBrief"].'
';} if(!empty($rsContent["ImageSMPath"])){$sImg=$sSiteURL."media/imgAll/".$rsContent["ImageSMPath"];} if(!empty($rsContent["URLAlies"])){$sURLAlice=$rsContent["URLAlies"];} $sURL=$sSiteURL.$sURLAlice.'/'.$rsContent["ContentID"]; ?>
';} if(!empty($rsContent["ContentHeading"])){$sHead=$rsContent["ContentHeading"];} if(!empty($rsContent["ContentBrief"])){$sContentBrief=''.$rsContent["ContentBrief"].'
';} if(!empty($rsContent["ImageSMPath"])){$sImg=$sSiteURL."media/imgAll/".$rsContent["ImageSMPath"];} if(!empty($rsContent["URLAlies"])){$sURLAlice=$rsContent["URLAlies"];} $sURL=$sSiteURL.$sURLAlice.'/'.$rsContent["ContentID"]; ?>
';} if(!empty($rsContent["ContentHeading"])){$sHead=$rsContent["ContentHeading"];} if(!empty($rsContent["ContentBrief"])){$sContentBrief=''.$rsContent["ContentBrief"].'
';} if(!empty($rsContent["ImageSMPath"])){$sImg=$sSiteURL."media/imgAll/".$rsContent["ImageSMPath"];} if(!empty($rsContent["URLAlies"])){$sURLAlice=$rsContent["URLAlies"];} $sURL=$sSiteURL.$sURLAlice.'/'.$rsContent["ContentID"]; $sDateTime=$rsContent["fDateTimeInserted"]; ?>
0){$qCoutner="SELECT COUNT(ContentID) AS numrows FROM bn_content WHERE CategoryID=".$iCategoryID." AND Deletable=1";
}else{$qCoutner="SELECT COUNT(ContentID) AS numrows FROM bn_content WHERE Deletable=1";}
$result=mysqli_query($connEMM, $qCoutner) or die("Error...");
$row=mysqli_fetch_assoc($result);
$numrows=$row["numrows"];
$maxPage=ceil($numrows/$rowsPerPage);
$self=$_SERVER["PHP_SELF"];$nav="";
for($page=1;$page<=$maxPage;$page++){if($page==$pageNum){$nav.=" $page ";}else{$nav.=" $page ";}}
if($pageNum>1){
$page=$pageNum-1;
$prev=' « আগের পৃষ্ঠা আগের পৃষ্ঠা ';
}else{$prev=" ";$first=" ";}
if($pageNum<$maxPage){
$page=$pageNum+1;
$next=' পরের পৃষ্ঠা ';
}else{$next=" ";$last=" ";}mysqli_free_result($result); ?>
=DATE(NOW())-INTERVAL 60 DAY ORDER BY bn_totalhit.TotalHit DESC LIMIT 10";
$sSQL="SELECT bn_content.ContentID, bn_content.ContentSubHeading, bn_content.ContentHeading, bn_content.ImageSMPath, bn_content.URLAlies FROM bn_content INNER JOIN bn_totalhit ON bn_totalhit.ContentID=bn_content.ContentID WHERE bn_content.ShowContent=1 AND bn_content.Deletable=1 AND bn_content.CategoryID=".$iCategoryID." ORDER BY bn_totalhit.TotalHit DESC LIMIT 10";
$resultSQL=@mysqli_query($connEMM, $sSQL) or die(" ");
while($rsSQL=@mysqli_fetch_assoc($resultSQL)){
$sSubHead="";$sHead="";$sImg="";$sURL="";
if(!empty($rsSQL["ContentSubHeading"])){$sSubHead=''.$rsSQL["ContentSubHeading"].'
';} if(!empty($rsSQL["ContentHeading"])){$sHead=$rsSQL["ContentHeading"];} if(!empty($rsSQL["ImageSMPath"])){$sImg='';}else{$sImg="";} if($rsSQL["URLAlies"]!=""){$sURL=$sSiteURL.fFormatURL($rsSQL["URLAlies"]).'/'.$rsSQL["ContentID"];}else{$sURL=$sSiteURL.fFormatURL($sHead)."/".$rsSQL["ContentID"];} ?>
';} if(!empty($rsSQL["ContentHeading"])){$sHead=$rsSQL["ContentHeading"];} if(!empty($rsSQL["ImageSMPath"])){$sImg='';}else{$sImg="";} if($rsSQL["URLAlies"]!=""){$sURL=$sSiteURL.fFormatURL($rsSQL["URLAlies"]).'/'.$rsSQL["ContentID"];}else{$sURL=$sSiteURL.fFormatURL($sHead)."/".$rsSQL["ContentID"];} ?>