<?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,4");
	
if($compDATA['admin_product_option']=='Both')
{
	 $sql_hot=db_query("select * from tbl_category where 1 and category_status='Active' and category_is_hot='Yes' order by rand() limit 0,4");

$sql_hot_pro=db_query("select * from tbl_category where 1 and category_status='Active' and category_is_product='Yes' and category_is_hot='Yes' order by rand() limit 0,4");
if(mysqli_num_rows($sql_hot_pro)>0)
{$hot_pro=1;}
else
{$hot_pro=0;}

$sql_hot_ser=db_query("select * from tbl_category where 1 and category_status='Active' and category_is_product='No' and category_is_hot='Yes' order by rand() limit 0,4");
if(mysqli_num_rows($sql_hot_ser)>0)
{$hot_ser=1;}
else
{$hot_ser=0;}

}
elseif($compDATA['admin_product_option']=='Yes')
{
	 $sql_hot=db_query("select * from tbl_category where 1 and category_status='Active' and category_is_product='Yes' and category_is_hot='Yes' order by rand() limit 0,4");

}
else
{
	 $sql_hot=db_query("select * from tbl_category where 1 and category_status='Active' and category_is_product='No' and category_is_hot='Yes' order by rand() limit 0,4");

}



	if(mysqli_num_rows($sql_hot)>0){
		 ?>
<div class="container">
<div class="row">
      <div class="col-md-12">
        <section>
          <h2 class="section-title">
		  Hot
		 <?php 
		 if($compDATA['admin_product_option']=='Both')
		 {
	 
if($hot_pro==0)
{?>
	services
<?php 
}elseif($hot_ser==0)
{?>
	products
<?php }else {
	?>
	Products & Services
<?php 	
} 
		 }
	 
		 elseif($compDATA['admin_product_option']=='Yes'){ 
		 ?>
		 Products
		 <? }else{ ?>
		 Services
		 <? } ?>
		  
		  </h2>
        </section>
      </div>
    </div>
    </div>
<div id="feature">
  <div class="container">
    <div class="row">
      <?php
	  while($HOT_DATA=mysqli_fetch_array($sql_hot)){
	  @extract($HOT_DATA);
	?>
      <div class="col-md-3 feature-item">
        
        
          <?if($HOT_DATA['category_image_alt_title']=="")
        {
        
        
           if($HOT_DATA['category_is_product']=="Yes")
                      {
                          ?>
            <img src="<?=$site_url?>/uploaded_files/<?=$HOT_DATA['category_image_name']?>" title="<?=$HOT_DATA['category_name']?> manufacturer supplier exporter importer dealer in <?=$compDATA['admin_address']?> <?=$compDATA['admin_city']?> <?=$compDATA['admin_country']?>" alt="<?=$HOT_DATA['category_name']?>  manufacturer supplier exporter importer dealer in <?=$compDATA['admin_address']?> <?=$compDATA['admin_city']?> <?=$compDATA['admin_country']?>" width="100%" height="200" />                 
            <? 
            }
                     else if($HOT_DATA['category_is_product']=="No")
                      {
                          ?>
                        <img src="<?=$site_url?>/uploaded_files/<?=$HOT_DATA['category_image_name']?>" title="<?=$HOT_DATA['category_name']?> services in <?=$compDATA['admin_address']?> <?=$compDATA['admin_city']?> <?=$compDATA['admin_country']?>" alt="<?=$HOT_DATA['category_name']?> services in <?=$compDATA['admin_address']?> <?=$compDATA['admin_city']?> <?=$compDATA['admin_country']?>" width="100%" height="200" />            
                        <?}
                      ?>
                      
        
        
        
       <!-- <img src="<?=$site_url?>/uploaded_files/<?=$HOT_DATA['category_image_name']?>" alt="<?=$HOT_DATA['category_name']?>" title="<?=$HOT_DATA['category_name']?>" width="100%" height="200" />-->
        
        <?}else{?>
    
        
        <img src="<?=$site_url?>/uploaded_files/<?=$HOT_DATA['category_image_name']?>" alt="<?=$HOT_DATA['category_image_alt_title']?>" title="<?=$HOT_DATA['category_image_alt_title']?>" width="100%" height="200" />
        
        
        <?}?>
        
        
        
        
        
        
        
        <div class="content">
          <h3 class="heading"><?=$HOT_DATA['category_name']?></h3>
           <?php $description=strip_tags($HOT_DATA['category_description']);?>
          <p class="desc"><?=substr($description,0,100);?></p>
          <div class="read-more-btn"> <a href="<?=$site_url?>/<?=$HOT_DATA['category_url']?>.html" class="read-more mdl-button mdl-js-button mdl-js-ripple-effect mdl-button--raised mdl-button--accent">read more</a> </div>
        </div>
      </div>
      <? } ?>
    </div>
  </div>
</div>
<? } ?>