<?php include("site-header.php");?>
  <div>
    <?php include("site-left-menu.php");?>
	<?php
	 $searchKeyword=$_REQUEST['searchtext'];
	 $count=db_scalar("select count(*) from  tbl_category where 1 and  category_name like '%$_REQUEST[searchtext]%' and category_status='Active'");
	?>
    <div class="w680px fl mt10px ml20px">
      <div>
        <h3>
          <p class="gray large">Search Result<span style="color:#C10000; font-weight:bold; margin-left:100px; font-size:14px;">
            <?php if($count>0){?>
            "Total&nbsp;
            <?=$count?>
            &nbsp;Search Found"
            <? } ?></span></p>
        </h3>
        <p class="bdrB1 mt5px"></p>
        <p class="fr black2"><span class="mr5px"><a href="<?=$site_url?>/index.html">Home</a></span>&raquo; <span class="ml5px">Search Result</span></p>
      </div>
	  
	   <?php if($count==0) {?>
          <p align="center" style="color:#C10000; font-weight:bold; font-size:18px; margin-top:25px; margin-bottom:30px; ">No Search Found !!<br/>
            <br />
            Please Enter Valid Keyword..</p>
          <? } ?>
	  
	  
	  
	  
      <div class="mt30px">
        <?php    
	  $sql_category=db_query("select * from tbl_category where 1 and category_name LIKE '%$searchKeyword%' and category_status='Active' order by category_order_by asc");
	   if(mysqli_num_rows($sql_category)>0){
	    while($MAIN_CAT=mysqli_fetch_array($sql_category)){
	    @extract($MAIN_CAT);
	   ?>
        <div class="mt20px bg7 bd">
          <h4>
            <p class="p5px gray xlarge"><a href="<?=$site_url?>/<?=$MAIN_CAT['category_url']?>.html">
                <?=ucwords(strtolower($MAIN_CAT['category_name']));?>
              </a></p>
          </h4>
          <p class="bd mt5px"></p>
          <div>
            <div class="fl w150px">
              <p class="p5px"><img src="<?=$site_url?>/uploaded_files/<?=$MAIN_CAT['category_image_name']?>" alt="<?php if($MAIN_CAT['category_is_product']=='Yes'){ ?> Manufacturers Exporters and Wholesale Suppliers of <?=$MAIN_CAT['category_name']?> <?php echo $compDATA['admin_city']; ?> <?php echo $compDATA['admin_state']; ?> <? }else{ ?> Service Provider of <?=$MAIN_CAT['category_name']?> <?php echo $compDATA['admin_city']; ?> <?php echo $compDATA['admin_state']; ?> <? } ?>" title="<?php if($MAIN_CAT['category_is_product']=='Yes'){ ?> Manufacturers Exporters and Wholesale Suppliers of <?=$MAIN_CAT['category_name']?> <?php echo $compDATA['admin_city']; ?> <?php echo $compDATA['admin_state']; ?> <? }else{ ?> Service Provider of <?=$MAIN_CAT['category_name']?> <?php echo $compDATA['admin_city']; ?> <?php echo $compDATA['admin_state']; ?> <? } ?>" width="140" height="110" /></p>
            </div>
			<?php $description=strip_tags($MAIN_CAT['category_description']);?>
            <div class="fl w550px ml10px mt5px aj lh15em gray"><?=substr($description,0,450);?><em class="orange ml10px"><a href="<?=$site_url?>/<?=$MAIN_CAT['category_url']?>.html">Read more..</a></em></div>
            <p class="cb"></p>
          </div>
		  <?php
	 $sql_subcategory=db_query("select * from tbl_category where 1 and category_parent_id='$MAIN_CAT[category_id]' and category_status='Active' order by category_order_by asc");
	 if(mysqli_num_rows($sql_subcategory)>0){
	 while($SUB_CAT=mysqli_fetch_array($sql_subcategory)){
	 @extract($SUB_CAT);
	?>
          <div class="mt10px p5px fl w220px u gray"><span class="mr5px"><img src="<?=$site_url?>/images/arr-d.png" class="vam"  /></span><span><a href="<?=$site_url?>/<?=$SUB_CAT['category_url']?>.html"><?=ucwords(strtolower($SUB_CAT['category_name']));?></a></span></div>
          <? }} ?>
          <p class="cb"></p>
        </div>
		<? }} ?>
        <p><img src="<?=$site_url?>/images/spacer.gif" height="30" /></p>
        <p class="cb"></p>
      </div>
      <p class="cb"></p>
    </div>
    <p class="cb"></p>
  </div>
</div>
<?php include("site-footer.php");?>