এই বিভাগের জনপ্রিয়
=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"];}
?>