<?php
$sql_hot=db_query("select * from tbl_category where 1 and category_status='Active' and category_is_hot='Yes'  order by rand() limit 0,3");
if(mysqli_num_rows($sql_hot)>0){
?>
<div id="services-section" class="ptb ptb-xs-60">
    <div class="container">
      <div class="row">
        <div class=" col-sm-12">
          <div class=" about-wrap">
            <div class="block-title v-line">
              <h2><span>Hot</span> <?php if($compDATA['admin_product_option']=='Yes'){ ?>Products<? }else{ ?>Services<? } ?></h2>

            </div>            
          </div>
        </div>
        
       
        
        <div class="col-sm-12 col-md-12" style="margin-top:25px;">
          <div class="block_wrapper mt-xs-30">
            
<?php
while($HOT_DATA=mysqli_fetch_array($sql_hot)){
@extract($HOT_DATA);
?>             
            
            <div class="col-md-4">
              <div class="about-block black-bg light-color hover-bg clearfix">
                <div class="block_pic"> <a href="<?=$site_url?>/<?=$HOT_DATA['category_url']?>.html"><img class="img-responsive" 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:190px;"></a> </div>
                <div class="text-box padding-20 pt-30">
                  <div class="box-title">
                    <h3 class="mt-0"><a href="<?=$site_url?>/<?=$HOT_DATA['category_url']?>.html"><?=$HOT_DATA['category_name']?></a></h3>
                  </div>
                  <div class="text-content">
                    <p> <?=substr($description,0,60);?> </p>
                  </div>
                  <div class="box-title">
                    <h3 class="mt-0 italic"><a href="<?=$site_url?>/<?=$HOT_DATA['category_url']?>.html">read more</a></h3>
                    </div>
                </div>
              </div>
            </div>
<?php
}
?>

          
                        
          </div>
        </div>
      </div>
    </div>
  </div>
<?php 
}
?>