<?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">



<head>

    <meta charset="utf-8">

    <meta http-equiv="X-UA-Compatible" content="IE=edge">

    <?php include "app_top.php"; ?>

</head>



<body>



    <?php include "app_header.php"; ?>





    <section 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">

                    <h1 class="cat_title">Market Area</h1>

                    <div class="clearfix"></div>

                    <!-- <div class="cat_title2">We Are Available For You</div> -->

                </div>

            </div>

        </div>

    </section>



    <div class="inner_breadcrumb hidden_xs">

        <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">

                    <ul class="breadcrumb">

                        <li><a href="<?=site_url;?>" title="Home">Home</a></li>

                        <li class="active">Market Area</li>

                    </ul>

                </div>

            </div>

        </div>

    </div>



    <section class="sitemap_page">

        <div class="container">

            <div class="market_area">
            <?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)>'1'){
?>

                <h2 class="mt25">Overseas Locations</h2>
                <?php }else{ ?>
                <h2 class="mt25">Market Area</h2>
                <?php } ?>
                <ul class="market-list">
                <?php
while($res_loc=mysqli_fetch_array($sql_loc)) {  
    $loc_url = $res_loc['loc_url'] ? $res_loc['loc_url'] : $res_loc['locationName'];
    ?>

                    <li><a href="<?=site_url;?>/<?php echo getValidFileName(strtolower($loc_url)); ?>/" title="<?php echo $res_loc['locationName'];?>"><?php echo $res_loc['locationName'];?></a></li>
                    <?php } ?>
                   

                    

                </ul>

              

                <h3 class="mt25">States of India</h3>

                <ul class="market-list">
                <?php
$sql_locsss=mysqli_query($GLOBALS['dbconn'],"select locationName, parentID, locationID, loc_url from location_tbl where parentID='1' 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'];
    ?>


                    <li><a href="<?=site_url;?>/<?php echo getValidFileName(strtolower($loc_url1)); ?>/" title="<?php echo $res_locsss['locationName'];?>"><?php echo $res_locsss['locationName'];?></a></li>


<?php } ?>
                

                </ul>

                <?php
$sql_loccc=mysqli_query($GLOBALS['dbconn'],"select locationName, parentID, locationID, loc_url from location_tbl where parentID ='1' 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 class="mt25">Cities of <?php echo $res_loccc['locationName']; ?></h3>

                <ul class="market-list">
                <?php while($res_locfinal=mysqli_fetch_array($sql_loc1))  { 
                    $loc_url2 = $res_locfinal['loc_url'] ? $res_locfinal['loc_url'] : $res_locfinal['locationName'];
                    ?>
                    <li><a href="<?=site_url;?>/<?php echo getValidFileName(strtolower($loc_url2)); ?>/" title="<?php echo $res_locfinal['locationName']; ?>"><?php echo $res_locfinal['locationName']; ?></a></li>
                    <?php } ?>
                </ul>

                <?php } } ?>
            </div>



        </div>

    </section>



    <?php include "app_footer.php";?>

    <?php include "app_bottom.php";?>

</body>



</html>