<?php
$sql_index_gal = db_query("SELECT * FROM tbl_category WHERE category_for_gallery='Yes' AND category_status='Active' ORDER BY category_order_by ASC");
if (mysqli_num_rows($sql_index_gal) > 0) {
?>
<div class="gallery-container">
  <div class="row">
    <div class="col-md-12">
      <section>
        <h2 class="gallery-title"><?php echo ($compDATA['admin_product_option'] == 'Yes') ? 'Products' : 'Services'; ?> Gallery</h2>
      </section>
    </div>
  </div>
  <div class="slider-wrapper">
    <div id="main-slider" class="flexslider carousel">
      <ul class="slides">
        <?php
        while ($INDEXGAL_DATA = mysqli_fetch_array($sql_index_gal)) {
          @extract($INDEXGAL_DATA);
        ?>
        <li> 
          <a href="<?=$site_url?>/<?=$INDEXGAL_DATA['category_url']?>.html" class="portfolio-img-link">
            <img src="<?=$site_url?>/uploaded_files/<?=$INDEXGAL_DATA['category_image_name']?>" alt="<?php echo ($INDEXGAL_DATA['category_is_product'] == 'Yes') ? 'Manufacturers Exporters and Wholesale Suppliers of '.$INDEXGAL_DATA['category_name'].' '.$compDATA['admin_city'].' '.$compDATA['admin_state'] : 'Service Provider of '.$INDEXGAL_DATA['category_name'].' '.$compDATA['admin_city'].' '.$compDATA['admin_state']; ?>" title="<?php echo ($INDEXGAL_DATA['category_is_product'] == 'Yes') ? 'Manufacturers Exporters and Wholesale Suppliers of '.$INDEXGAL_DATA['category_name'].' '.$compDATA['admin_city'].' '.$compDATA['admin_state'] : 'Service Provider of '.$INDEXGAL_DATA['category_name'].' '.$compDATA['admin_city'].' '.$compDATA['admin_state']; ?>" />
          </a>
        </li>
        <?php } ?>
      </ul>
    </div>
  </div>
</div>
<?php } ?>