<?php
	 //$sql_feature=db_query("select * from tbl_category where 1 and category_status='Active' and category_is_featured='Yes' order by rand() limit 0,3");
	 
	  if($compDATA['admin_product_option']=='Both')
	 {
	 $sql_feature=db_query("select * from tbl_category where 1 and category_status='Active' and category_is_featured='Yes' order by rand() limit 0,3");
	 
	
$sql_feature_pro=db_query("select * from tbl_category where 1 and category_status='Active' and category_is_product='Yes' and category_is_featured='Yes' order by rand() limit 0,3");
if(mysqli_num_rows($sql_feature_pro)>0)
{$sql_feature_pro=1;}
else
{$sql_feature_pro=0;}



$sql_feature_ser=db_query("select * from tbl_category where 1 and category_status='Active' and category_is_product='No' and category_is_featured='Yes' order by rand() limit 0,3");
if(mysqli_num_rows($sql_feature_ser)>0)
{$sql_feature_ser=1;}
else
{$sql_feature_ser=0;}
	     
	     
	     
	 }
	 elseif($compDATA['admin_product_option']=='Yes')
	 {
	 $sql_feature=db_query("select * from tbl_category where 1 and category_status='Active' and category_is_product='Yes' and category_is_featured='Yes' order by rand() limit 0,3");		 
	 }
	 elseif($compDATA['admin_product_option']=='No'){
	$sql_feature=db_query("select * from tbl_category where 1 and category_status='Active' and category_is_product='No' and category_is_featured='Yes' order by rand() limit 0,3");		 	 
		 
	 }
	 if(mysqli_num_rows($sql_feature)>0){
		 ?>
<div id="blog">
  <div class="container">
    <div class="row">
      <div class="col-md-12">
        <section>
          <h2 class="section-title">
		 <?php
		  if($compDATA['admin_product_option']=='Both')
		  {
			  	 
if($sql_feature_pro==0)
{?>
	Featured Services
<?php 
}elseif($sql_feature_ser==0)
{?>
	Featured Products
<?php 
    
}else {
	?>
	Featured Products & Services
<?php 	
} 
		?>
		
		 <?php }
		  elseif($compDATA['admin_product_option']=='Yes'){ ?>
		  Featured Products
		  <? 
		  }else
			{
			?>
			Featured Services
			<? } ?>

	  
		  </h2>
        </section>
      </div>
    </div>
    <div class="row">
       <?php
	  while($FEATURE_DATA=mysqli_fetch_array($sql_feature)){
	   @extract($FEATURE_DATA);
	?>
      <div class="col-md-4 col-sm-6 post-item">
        <div class="mdl-card mdl-shadow--2dp">
          <div class="mdl-card__title">
            <div class="post-img"> <a href="<?=$site_url?>/<?=$FEATURE_DATA['category_url']?>.html">
                
               <?
                if($FEATURE_DATA['category_image_alt_title']=="")
                {
                    
                    
                if($FEATURE_DATA['category_is_product']=="Yes" && $FEATURE_DATA['category_image_atl_title']=="")
                {?>
                  
                  

                   <img  src="<?=$site_url?>/uploaded_files/<?=$FEATURE_DATA['category_image_name']?>"  
                   title="<?=$FEATURE_DATA['category_name']?> manufacturer supplier exporter importer dealer in <?=$compDATA['admin_address']?> <?=$compDATA['admin_city']?> <?=$compDATA['admin_country']?>" alt="<?=$FEATURE_DATA['category_name']?> manufacturer supplier exporter importer dealer in <?=$compDATA['admin_address']?> <?=$compDATA['admin_city']?> <?=$compDATA['admin_country']?>" width="100%" height="200">
                    
                <?} 
                else if($FEATURE_DATA['category_is_product']=="No" && $FEATURE_DATA['category_image_atl_title']=="")
                {?>
              
                 <img  src="<?=$site_url?>/uploaded_files/<?=$FEATURE_DATA['category_image_name']?>"  title="<?=$FEATURE_DATA['category_name']?> services in <?=$compDATA['admin_address']?> <?=$compDATA['admin_city']?> <?=$compDATA['admin_country']?>" alt="<?=$FEATURE_DATA['category_name']?> services in <?=$compDATA['admin_address']?> <?=$compDATA['admin_city']?> <?=$compDATA['admin_country']?>" width="100%" height="200">
                    
                <?}
                
                
                
                
                
                }
             else {
                ?>
                <img  src="<?=$site_url?>/uploaded_files/<?=$FEATURE_DATA['category_image_name']?>" alt="<?=$FEATURE_DATA['category_image_alt_title']?>" title="<?=$FEATURE_DATA['category_image_alt_title']?>" width="100%" height="200">
                
                <?}?>
                
                
                </a> </div>
          </div>
          <div class="mdl-card__supporting-text">
            <section class="post-title">
              <h2><a href="<?=$site_url?>/<?=$FEATURE_DATA['category_url']?>.html">
      <?=$FEATURE_DATA['category_name']?>
      </a></h2>
            </section>
            <div class="post-summary" style="min-height:90px;">
            <?php $description=strip_tags($FEATURE_DATA['category_description']);?>
              <p><?=substr($description,0,150);?></p>
            </div>
          </div>
          <div class="mdl-card__actions mdl-card--border clearfix"> <a href="<?=$site_url?>/<?=$FEATURE_DATA['category_url']?>.html" class="read-more mdl-button mdl-js-button mdl-button--raised mdl-js-ripple-effect mdl-button--accent">read more</a> <a href="<?=$site_url?>/enquiry.html" class="comments pull-right mdl-button mdl-js-button mdl-js-ripple-effect">ENQUIRY</a> </div>
        </div>
      </div>
      <? } ?>
    </div>
  </div>
</div>
<? } ?>