<?php
include_once("include/main.inc.php");
$page_metatitle = "Market Area - " . $admin_res['companyName'];
$page_metakey = "Market Area - " . $admin_res['companyName'];
$page_metadesc = "Market Area - " . $admin_res['companyName'];
?>
<!DOCTYPE html>
<html lang="en" itemscope>
<head itemscope >
<meta charset="utf-8">
<?php include "app_top.php"; ?>
</head>
<body itemscope >
    <?php include "app_header.php"; ?>
    <div class="heading_banner" style="background-image: url(<?=site_url;?>/designer/images/market-banner.jpg)">
        <div class="container">
            <div class="row">
                <div class="col-xxl-12 col-xl-12 col-lg-12 col-md-12 col-sm-12 col-12 text-center">
                    <div class="cat_title">Market Area - <?=$admin_res['companyName'];?></div>
                    <div class="clearfix"></div>
                </div>
            </div>
        </div>
    </div>
    <div class="breadcrumbSection hidden_xs">
        <div class="container">
            <div class="row">
                <div class="col-lg-12">
                    <ul class="breadcrumb">
                        <li><a href="<?=site_url;?>" title="Home">Home</a></li>
                        <li class="active">Market Area</li>
                    </ul>
                </div>
            </div>
        </div>
    </div>
    <div class="market-sec">
        <div class="container">
<?php 
$sql_loc=mysqli_query($GLOBALS['dbconn'],"select locationName, parentID, locationID,loc_url from location_tbl where parentID='0' and status='Y' order by locationName asc");
if(mysqli_num_rows($sql_loc)> 0){
?>
            <h1 class="main-tt">Countries</h1>
<?php }else{ ?>
             <h1 class="main-tt">Market Area</h1>
               <?php } ?>
            <div class="row g-2 row-cols-2 row-cols-md-4 row-cols-lg-5">
                <?php
while($res_loc=mysqli_fetch_array($sql_loc)) { 
    $loc_url=$res_loc['loc_url']?$res_loc['loc_url']:$res_loc['locationName']; ?>
                <div class="col">
                    <a href="<?=site_url;?>/<?php echo getValidFileName($loc_url); ?>/" title="<?php echo $res_loc['locationName'];?>" class="market-bx"><?php echo $res_loc['locationName'];?></a>
                </div>
                <?php }?>
            </div>
            <h2>States of India</h2>
            <div class="row g-2 row-cols-2 row-cols-md-4 row-cols-lg-5">
                  <?php
$sql_locsss=mysqli_query($GLOBALS['dbconn'],"select locationName, parentID, locationID,loc_url from location_tbl where parentID='95' and status='Y' order by locationName asc");
while($res_locsss=mysqli_fetch_array($sql_locsss)) { 
    $loc_url1=$res_locsss['loc_url']?$res_locsss['loc_url']:$res_locsss['locationName'];
    ?>
                <div class="col">
                    <a href="<?=site_url;?>/<?php echo getValidFileName($loc_url1); ?>/" title="<?php echo $res_locsss['locationName'];?>" class="market-bx"><?php echo $res_locsss['locationName'];?></a>
                </div>
                <?php } ?>
            </div>
 <?php
$sql_loccc=mysqli_query($GLOBALS['dbconn'],"select locationName, parentID, locationID,loc_url from location_tbl where parentID ='95' order by locationName asc");
while($res_loccc=mysqli_fetch_array($sql_loccc))
{
$locationID=$res_loccc['locationID'];
$sql_loc1=mysqli_query($GLOBALS['dbconn'],"select locationName, parentID, locationID,loc_url from location_tbl where parentID ='$locationID' and status='Y' order by locationName asc");
if (mysqli_num_rows($sql_loc1) > 0)
{
?>
             <h3>Cities of <?=$res_loccc['locationName'];?> </h3>
            <div class="row g-2 row-cols-2 row-cols-md-4 row-cols-lg-5">
                 <?php while($res_locfinal=mysqli_fetch_array($sql_loc1))  { 
$loc_url2=$res_locfinal['loc_url']?$res_locfinal['loc_url']:$res_locfinal['locationName'];
?>
                <div class="col">
                    <a href="<?=site_url;?>/<?php echo getValidFileName($loc_url2); ?>/" title="<?php echo $res_locfinal['locationName'];?>" class="market-bx"><?php echo $res_locfinal['locationName'];?></a>
                </div>
                <?php }  ?>
</div>
           <?php } }?>
        </div>
    </div>
    <?php include "app_footer.php"; ?>
    <?php include "app_bottom.php"; ?>
</body>
</html>