<?php
$sql_hot=db_query("select * from tbl_category where 1 and category_status='Active' and category_is_hot='Yes' and category_parent_id=0 order by rand() limit 0,3");
if(mysqli_num_rows($sql_hot)>0){
	?>
<section class="bg-lighter">
  <div class="container pb-30">
    <div class="section-title title-border icon-bg">
      <div class="row">
        <div class="col-md-12">
          <h2 class="mt-0 page-title"><i class="fa fa-legal"></i>Hot
            <?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-xs-12 col-sm-6 col-md-4 mb-30">
          <div class="box-hover-effect effect2 bg-lightest-gray p-10 maxwidth400">
            <div class="thumb"> <img class="img-responsive" style="width:100%; height:215px;"  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']; ?> <? } ?>"   >
              <div class="overlay white">
                <div class="display-table">
                  <div class="display-table-cell">
                    <div class="overlay-details text-center">
                      <h4 class="text-theme-colored mt-0">
                        <?=$HOT_DATA['category_name']?>
                      </h4>
                      <?php $description=strip_tags($HOT_DATA['category_description']);?>
                      <p class="pl-20 pr-20">
                        <?=substr($description,0,60);?>
                      </p>
                      <a class="btn btn-dark btn-theme-colored btn-xs" href="<?=$site_url?>/<?=$HOT_DATA['category_url']?>.html">Read more</a> </div>
                  </div>
                </div>
              </div>
              <div class="details">
                <h5 class="text-theme-colored mt-5">
                  <?=$HOT_DATA['category_name']?>
                </h5>
                <div class="mb-5">
                  <?=substr($description,0,60);?>
                </div>
                <a class="btn btn-dark btn-theme-colored btn-xs mt-5 " href="<?=$site_url?>/<?=$HOT_DATA['category_url']?>.html">Read more</a> </div>
            </div>
          </div>
        </div>
        <?php
}
?>
        <div class="col-lg-12 text-right"><a  href="<?=$site_url?>/products.html" class="all-prd-link">View All Products &raquo;</a></div>
      </div>
    </div>
  </div>
</section>
<? } ?>