<?php

include_once("include/main.inc.php");
$page_metatitle = "Online Numerology Consultancy Services in India | Acharya Vijay Shastri";

$page_metakey = "Online Numerology Consultancy Services in India, Numerology Expert in India, Acharya Vijay Sharstriji, Online Numerologist India, Numerology Consultation India, Best Numerologist in India, Online Numerology";

$page_metadesc = "Looking for trusted Online Numerology Consultancy Services in India? Connect with Acharya Vijay Shastri for expert numerology guidance and personalized online consultations in your area.";
?>
<!DOCTYPE html>
<html lang="en">

<head>
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
 
    <?php include 'apps/app_top.php'; ?>
</head>

<body>
    <?php include 'apps/app_header.php'; ?>

    <div class="heading_banner" style="background-image: url(<?=site_url;?>/assets/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>
            </div>
        </div>
    </div>

    <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)> 0){

?>

                <h2 class="mt25">Countries</h2>
                <?php }else{ ?>
                <h2 class="mt25">Countries</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($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($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($loc_url2); ?>/" title="<?php echo $res_locfinal['locationName'];?>"><?php echo $res_locfinal['locationName'];?></a></li>
                    <?php }  ?>
                </ul>
                <?php } } ?>


                <?php

$sql_loccc1=mysqli_query($GLOBALS['dbconn'],"select locationName, parentID, locationID,loc_url from location_tbl where parentID ='0' && locationId!='1' order by locationName asc");

while($res_loccc1=mysqli_fetch_array($sql_loccc1))

{

$locationID=$res_loccc1['locationID'];

$sql_loc12=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_loc12) > 0)

{

?>
                <h3 class="mt25">Cities of <?php echo $res_loccc1['locationName']; ?></h3>

                <ul class="market-list">
                <?php while($res_locfinal1=mysqli_fetch_array($sql_loc12))  { 

$loc_url2=$res_locfinal1['loc_url']?$res_locfinal1['loc_url']:$res_locfinal1['locationName'];

?>
                    <li><a href="<?=site_url;?>/<?php echo getValidFileName($loc_url2); ?>/" title="<?php echo $res_locfinal1['locationName'];?>"><?php echo $res_locfinal1['locationName'];?></a></li>
                    <?php }  ?>
                </ul>
                <?php } } ?>
            </div>

        </div>
    </section>

    <?php include 'apps/app_footer.php'; ?>
    <?php include 'apps/app_bottom.php'; ?>
</body>

</html>