<?php
$sql_hot=db_query("select * from tbl_category where 1 and category_status='Active' and category_is_featured='Yes' and category_parent_id=0 order by rand() limit 0,4");
if(mysqli_num_rows($sql_hot)>0){
?>
<section>
  <div class="container pb-30">
    <div class="section-title title-border title-right icon-bg">
      <div class="row">
        <div class="col-md-12">
          <h2 class="mt-0 page-title"> <i class="fa fa-legal"></i>Featured
            <?php if($compDATA['admin_product_option']=='Yes'){ ?>
            Products
            <? }else{ ?>
            Services
            <? } ?>
          </h2>
        </div>
      </div>
    </div>
    <div class="section-content">
      <div class="row">
        <?php
while($HOT_DATA=mysqli_fetch_array($sql_hot)){
@extract($HOT_DATA);
?>
        <div class="col-sm-12 col-md-6">
          <div class="attorney box-hover-effect effect1 bg-lighter mb-30">
            <div class="row">
              <div class="col-sm-6 col-md-6 xs-text-center pb-sm-20">
                <div class="thumb"><img class="img-fullwidth cat-image-fix MoverImageFix" src="<?=$site_url?>/uploaded_files/<?=$HOT_DATA['category_image_name']?>" alt="<?php if($HOT_DATA['category_is_product']=='Yes'){ ?> Manufacturers Exporters and Wholesale Suppliers of <?=$HOT_DATA['category_name']?> <?php echo $compDATA['admin_city']; ?> <?php echo $compDATA['admin_state']; ?> <? }else{ ?> Service Provider of <?=$HOT_DATA['category_name']?> <?php echo $compDATA['admin_city']; ?> <?php echo $compDATA['admin_state']; ?> <? } ?>" title="<?php if($HOT_DATA['category_is_product']=='Yes'){ ?> Manufacturers Exporters and Wholesale Suppliers of <?=$HOT_DATA['category_name']?> <?php echo $compDATA['admin_city']; ?> <?php echo $compDATA['admin_state']; ?> <? }else{ ?> Service Provider of <?=$HOT_DATA['category_name']?> <?php echo $compDATA['admin_city']; ?> <?php echo $compDATA['admin_state']; ?> <? } ?>" style="width:100%; height:200px;"> </div>
              </div>
              <div class="col-sm-6 col-md-6 xs-text-center pb-sm-20">
                <div class="content">
                  <h4 class="author text-theme-colored mb-0">
                    <?=$HOT_DATA['category_name']?>
                  </h4>
                  <?php $description=strip_tags($HOT_DATA['category_description']);?>
                  <div class="mt-15">
                    <?=substr($description,0,110);?>
                  </div>
                  <a class="btn btn-theme-colored btn-xs mt-20" href="<?=$site_url?>/<?=$HOT_DATA['category_url']?>.html">Read more</a> </div>
              </div>
            </div>
          </div>
        </div>
        <?php
}
?>
        <div class="col-lg-12 text-center"><a  href="<?=$site_url?>/products.html" class="all-prd-link">View All Products &raquo;</a></div>
      </div>
    </div>
  </div>
</section>
<? } ?>