= DATE('$tDate') AND DATE(bc.DateTimeInserted) <= DATE('$sDate') ORDER BY bc.ContentID ";
}else if($_POST["dtDate"]!="" && $_POST["dsDate"]=="" && $_POST["catid"]=="0" ){
$tDate=$_POST["dtDate"];
$sDate=date("Y-m-d");
$q=" AND DATE(bc.DateTimeInserted) >= DATE('$tDate') AND DATE(bc.DateTimeInserted) <= DATE('$sDate') ORDER BY bc.ContentID ";
}else if($_POST["dtDate"]!="" && $_POST["dsDate"]!="" && $_POST["catid"]=="0" ){
$tDate=$_POST["dtDate"];
$sDate=$_POST["dsDate"];
$q=" AND DATE(bc.DateTimeInserted) >= DATE('$tDate') AND DATE(bc.DateTimeInserted) <= DATE('$sDate') ORDER BY bc.ContentID ";
}else if($_POST["dtDate"]!="" && $_POST["dsDate"]!="" && $_POST["catid"]=="0" ){
$tDate=$_POST["dtDate"];
$sDate=$_POST["dsDate"];
$q=" AND DATE(bc.DateTimeInserted) >= DATE('$tDate') AND DATE(bc.DateTimeInserted) <= DATE('$sDate') ORDER BY bc.ContentID ";
}else if($_POST["dtDate"]!="" && $_POST["dsDate"]!="" && $_POST["catid"]!="" ){
$tDate=$_POST["dtDate"];
$sDate=$_POST["dsDate"];
$q=" AND DATE(bc.DateTimeInserted) >= DATE('$tDate') AND DATE(bc.DateTimeInserted) <= DATE('$sDate') AND bc.CategoryID=".$iCategoryID." ORDER BY bc.ContentID ";
}else if($_POST["dtDate"]!="" && $_POST["dsDate"]!="" && $_POST["catid"]=="0" && $_POST["divid"]!="" && $_POST["disid"]=="0" ){
$tDate=$_POST["dtDate"];
$sDate=$_POST["dsDate"];
$q=" AND DATE(bc.DateTimeInserted) >= DATE('$tDate') AND DATE(bc.DateTimeInserted) <= DATE('$sDate') AND bas_district.DivisionID=".$iDivisionID." ORDER BY bc.ContentID ";
}else if($_POST["dtDate"]!="" && $_POST["dsDate"]!="" && $_POST["catid"]=="0" && $_POST["divid"]=="0" && $_POST["disid"]!="" ){
$tDate=$_POST["dtDate"];
$sDate=$_POST["dsDate"];
$q=" AND DATE(bc.DateTimeInserted) >= DATE('$tDate') AND DATE(bc.DateTimeInserted) <= DATE('$sDate') AND bc.DistrictID=".$iDistrictID." ORDER BY bc.ContentID ";
}else if($_POST["dtDate"]!="" && $_POST["dsDate"]!="" && $_POST["catid"]=="0" && $_POST["divid"]!="" && $_POST["disid"]!="" ){
$tDate=$_POST["dtDate"];
$sDate=$_POST["dsDate"];
$q=" AND DATE(bc.DateTimeInserted) >= DATE('$tDate') AND DATE(bc.DateTimeInserted) <= DATE('$sDate') AND bas_district.DivisionID=".$iDivisionID." AND bc.DistrictID=".$iDistrictID." ORDER BY bc.ContentID ";
}else if($_POST["dtDate"]!="" && $_POST["dsDate"]!="" && $_POST["catid"]!="" && $_POST["divid"]!="" && $_POST["disid"]!="" ){
$tDate=$_POST["dtDate"];
$sDate=$_POST["dsDate"];
$q=" AND DATE(bc.DateTimeInserted) >= DATE('$tDate') AND DATE(bc.DateTimeInserted) <= DATE('$sDate') AND bc.CategoryID=".$iCategoryID." AND bas_district.DivisionID=".$iDivisionID." AND bc.DistrictID=".$iDistrictID." ORDER BY bc.ContentID ";
}else if($_POST["dtDate"]=="" && $_POST["dsDate"]=="" && $_POST["catid"]=="0" ){
$tDate=$_POST["dtDate"];
$sDate=$_POST["dsDate"];
$q=" ORDER BY bc.ContentID ";
}else if($_POST["dtDate"]=="" && $_POST["dsDate"]=="" && $_POST["catid"]!="" ){
$q=" AND bc.CategoryID=".$iCategoryID." ORDER BY bc.ContentID ";
}else if($_POST["dtDate"]=="" && $_POST["dsDate"]=="" && $_POST["catid"]=="0" && $_POST["divid"]=="0" && $_POST["disid"]!="" ){
$q=" AND bc.DistrictID=".$iDistrictID." ORDER BY bc.ContentID ";
}else if($_POST["dtDate"]=="" && $_POST["dsDate"]=="" && $_POST["catid"]=="0" && $_POST["divid"]!="" && $_POST["disid"]=="0" ){
$q=" AND bas_district.DivisionID=".$iDivisionID." ORDER BY bc.ContentID ";
}else if($_POST["dtDate"]=="" && $_POST["dsDate"]=="" && $_POST["catid"]=="0" && $_POST["divid"]!="" && $_POST["disid"]!="" ){
$q=" AND bas_district.DivisionID=".$iDivisionID." AND bc.DistrictID=".$iDistrictID." ORDER BY bc.ContentID ";
}else{
$tDate=date("Y-m-d");
$sDate=date("Y-m-d");
$q=" AND bc.Deletable=1 AND DATE(bc.DateTimeInserted) = DATE('$tDate') GROUP BY bc.CategoryID";
}
}else{
$q=" ORDER BY bc.ContentID";
}
$q1=" DESC LIMIT 0, $rowperpage";
$qContent="SELECT bc.ContentID, bc.CategoryID, bn_bas_category.CategoryName, bn_bas_category.Slug, bn_bas_subcategory.Slug as subSlug, bc.SubCategoryID, bc.ContentHeading, bc.ContentSubHeading, bc.ContentBrief, bc.ImageSMPath, bc.URLAlies, DATE_FORMAT(bc.DateTimeInserted, '%h:%i %p, %e %M %Y %W') AS fDateTimeInserted FROM ".$db_content." bc INNER JOIN bn_bas_category ON bn_bas_category.CategoryID=bc.CategoryID JOIN bn_bas_subcategory ON bn_bas_subcategory.SubCategoryID=bc.SubCategoryID JOIN bas_district ON bas_district.DistrictID=bc.DistrictID WHERE bc.ShowContent=1 AND bc.Deletable=1";
$qContent.=$q;
$qContent.=$q1;
$resultContent=@mysqli_query($connEMM, $qContent) or die(" ");
$qCount="SELECT COUNT(ContentID) as totalcount FROM $db_content";
$resultCount=@mysqli_query($connEMM, $qCount) or die("");
while($rsCount=@mysqli_fetch_assoc($resultCount)){$totalRecord = $rsCount["totalcount"];}
while($rsContent=@mysqli_fetch_assoc($resultContent)){
$sContentID="";$sCatURL="";$sCatName="";$sHead="";$sSubHead="";$sBrief="";$sURL="";$sImg="";
if($rsContent["ContentID"]!=""){$sContentID=$rsContent["ContentID"];}
if($rsContent["CategoryName"]!=""){$sCatName=$rsContent["CategoryName"];}
$sCatURL=$sSiteURL.$rsContent["Slug"]."/";
if($rsContent["ContentSubHeading"]!=""){$sSubHead=''.$rsContent["ContentSubHeading"].'
';} if($rsContent["ContentHeading"]!=""){$sHead=$rsContent["ContentHeading"];} if($rsContent["ContentBrief"]!=""){$sBrief=$rsContent["ContentBrief"];} if($rsContent["ImageSMPath"]!=""){$sImg='
';}else{$sImg='
';}
$sURL=$sSiteURL.$rsContent["Slug"].'/news/'.$rsContent["ContentID"];
$sDateTime=$rsContent["fDateTimeInserted"]; ?>
';} if($rsContent["ContentHeading"]!=""){$sHead=$rsContent["ContentHeading"];} if($rsContent["ContentBrief"]!=""){$sBrief=$rsContent["ContentBrief"];} if($rsContent["ImageSMPath"]!=""){$sImg='