<?php
include_once("include/main.inc.php");
?>
<!DOCTYPE html>
<html lang="en">

<head>
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <title><?=COMPANY_NAME;?> - Market Area </title>
    <meta name="keywords" content="<?=COMPANY_NAME;?> - Market Area" />
    <meta name="description" content="<?=COMPANY_NAME;?> - Market Area" />
    <?php include 'components/top_header.php';?>
</head>

<body>
    <div class="webpulse-main-wrapper">
        <!-- Header-->
        <?php include 'components/header.php';?>


        <!-- Heading Banner-->
        <section class="heading_banner" style="background-image: url(<?=SITE_URL_PATH;?>/designer/images/testimonial/testimonial.jpg)">
            <div class="container">
                <div class="row">
                    <div class="col-lg-12 text-center">
                        <h1 class="cat_title"><strong>Market Area</strong></h1>
                        <div class="clearfix"></div>
                        
                    </div>
                </div>
            </div>
        </section>

        <!-- Breadcrumb -->
        <section class="inner_breadcrumb hidden-xs">
            <div class="container">
                <div class="row">
                    <div class="col-lg-12">
                        <ul class="breadcrumb">
                            <li><a href="<?=SITE_URL_PATH;?>" title="Home">Home</a></li>
                            <li class="active">Market Area</li>
                        </ul>
                    </div>
                </div>
            </div>
        </section>

        <!-- Home About-->
        <section class="sitemap_page">
            <div class="container">
                <div class="row">
                    <div class="col-lg-12 col-md-12 ">
                        <div class="sitemap_right_side">
                            <h1 class="bg-title">Market Area</h1>
                            <div class="wps_right">

                                <div class="col-lg-12 col-md-12">
                                                           
                                    <h2 class="bg-head">States</h2>


                                    <ul class="market-list">
                                    <?php

                                        $sql_loc=mysqli_query($GLOBALS['dbcon'],"select * from location_tbl where parentID='0' and status='Y' order by locationName asc");

                                        if(mysqli_num_rows($sql_loc))

                                        {

                                        while($res_loc=mysqli_fetch_array($sql_loc))

                                        {

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

                                    <?php

                                        }

                                        }

                                        else

                                        {

                                        $sql_loc=mysqli_query($GLOBALS['dbcon'],"select * from location_tbl where parentID='0' and status='Y' order by locationName asc");

                                        while($res_loc=mysqli_fetch_array($sql_loc))

                                        {

                                        ?>

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

                                    <?php

                                    }

                                    }

                                    ?>
</ul>
                       <h2 class="bg-head">Indian Cities</h2>
                       
                                <?php

                                $sql_loccc=mysqli_query($GLOBALS['dbcon'],"select * from location_tbl where parentID ='0' and status='Y'");



                                while($res_loc=mysqli_fetch_array($sql_loccc))

                                {

                                $locationID=$res_loc['locationID'];

                                $sql_loc1=mysqli_query($GLOBALS['dbcon'],"select * from location_tbl where parentID ='$locationID' and status='Y'");

                                if (mysqli_num_rows($sql_loc1) > 0)

                                {

                                ?>
                                   <ul class="market-list">
                                      <div class="clearfix"></div>
                                        <h3 class="name_title">Cities of <?php echo $res_loc['locationName']; ?></h3>
                                        

                                        <ul class="market-list">
                                            <?php
                                            $sql_loc1=mysqli_query($GLOBALS['dbcon'],"select * from location_tbl where parentID ='$locationID' and status='Y'");     
                                            while($res_loc1=mysqli_fetch_array($sql_loc1))
                                         
                                            { 
                                         
                                            ?>	
                                            <li><a href="<?=SITE_URL_PATH;?>/<?php echo getValidFileName(strtolower($res_loc1['locationName'])); ?>/" title="<?php echo ucwords($res_loc1['locationName']); ?>"><?php echo ucwords($res_loc1['locationName']); ?></a></li>
                                            <?php } ?>
                                           

                                        </ul>
                                            </ul>
                                        <?php } } ?>
                                     

                                </div>
                            </div>
                        </div>
                    </div>
                    <!-- <div class="col-lg-3 col-md-6 col-lg-pull-9">
                        <div class="left_sidebar">
                            <?php include 'components/quick_contact.php';?>
                        </div>
                        <div class="left_sidebar">
                            <?php include 'components/product_list.php';?>
                        </div>
                    </div> -->

                </div>
            </div>
        </section>



        

        <!-- Home Clients -->
        <!-- <section class="webpulse_home_clients">
            <div class="container">
                <div class="sec-title centered wow fadeInUp animated animated" data-wow-delay=".1s">
                    <h4 class="title-head text-dark">Our Clients</h4>
                    <div class="separator"></div>
                </div>
                <div class="clearfix"></div>
               
            </div>
        </section> -->

        <!-- Footer-->
        <?php include 'components/footer.php';?>
    </div>
    <?php include 'components/bottom_footer.php';?>
</body>

</html>