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

    <!-- Heading Banner--->
    <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>

    <!-- Breadcrumb--->
    <section 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>
    </section>

    <!-- <section class="sitemap_page">
        <div class="container">
            <div class="wps_right market_area">
                <h1 class="mt25">Country for example</h1>
                <ul class="market-list">                    
                    <li><a href="egypt">Egypt</a></li>                    
                </ul>
                <h3 class="mt25">States of India for example</h3>
                <ul class="market-list">
                    <li><a href="andhra-pradesh">Andhra Pradesh</a></li>
                    <li><a href="delhi">Delhi</a></li>
                </ul>         
            </div>
        </div>
    </section> -->

<section class="sitemap_page bg-white mt-1">
    <div class="container">
        <div class="wps_right market_area">
        <?php 
            $sql_loc=mysqli_query($GLOBALS['dbconn'],"select locationName, parentID, locationID from location_tbl where parentID='0' and status='Y' order by locationName asc");
            if(mysqli_num_rows($sql_loc)>0){
            ?>

            <h2 class="mt25">Countries</h2>
            <?php }else{  ?>

            <h2 class="mt25">Market Area</h2>
            <?php } ?>
            <ul class="market-list">
            <?php
        while($res_loc=mysqli_fetch_array($sql_loc)) {  ?>

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

            </ul>

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

            <ul class="market-list">

            <?php
        $sql_locsss=mysqli_query($GLOBALS['dbconn'],"select locationName, parentID, locationID from location_tbl where parentID='1' and status='Y' order by locationName asc");
        while($res_locsss=mysqli_fetch_array($sql_locsss)) {  ?>

            <li><a href="<?=site_url;?>/<?php echo getValidFileName(strtolower($res_locsss['locationName'])); ?>/" 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 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 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))  { ?>
                <li><a href="<?=site_url;?>/<?php echo getValidFileName(strtolower($res_locfinal['locationName'])); ?>/" 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>