<?php
$shwInHdr = db_scalar("select site_pages_show_in_header from tbl_site_pages where 1 and site_pages_link='$page_name'");
$link_sql=db_query("select * from tbl_site_pages where 1 and site_pages_status='Active' and site_pages_show_in_header='Yes' order by site_pages_order_by asc limit 0,5");
	  if(mysqli_num_rows($link_sql)>0){
?>
<ul class="nav">
  <?php 
	  while($link_data=mysqli_fetch_array($link_sql)){
	   $pgName=$link_data['site_pages_link'];
	   
	  ?>
  <?php if($pgName=='index'){ ?>
  <li><a href="<?=$site_url?>/<?=$link_data['site_pages_link']?>.html">
    <?=$link_data['site_pages_name']?>
    </a></li>
  <? }elseif($pgName=='products'){ ?>
  <li class="dropdown"><a href="<?=$site_url?>/<?=$link_data['site_pages_link']?>.html">
    <?=$link_data['site_pages_name']?>
    </a>
    <ul>
      <!--Showing N Lable Of Category Start Here.  query() And has_child() Function Initialized in header-->
      <?php
function fetch_header_menu($query) {
$site_url=db_scalar("select admin_website_url from tbl_admin where 1");
	while ( $result = mysqli_fetch_array ( $query ) ) {
		$menu_id = $result ['category_id'];
		$menu_name = ucwords(strtolower($result ['category_name']));
		$menu_cat_link = $result ['category_url'];
		if (has_child ( query ( $menu_id ) )) {
			$menuClass = "dropdown";
		}else{
		   $menuClass = "";
		}
 	  echo "<li class='{$menuClass}'><a href='$site_url/{$menu_cat_link}.html'>{$menu_name}</a>";
		if (has_child ( query ( $menu_id ) )) {
			echo "<ul>";
			fetch_header_menu ( query ( $menu_id ) );
			echo "</ul>";
		}
		echo "</li>";
	}
}
fetch_header_menu (query(0)); //call this function with 0 parent id
?>
      <!--Showing N Lable Of Category End Here.  query() And has_child() Function Initialized in header-->
    </ul>
  </li>
  <? }else{ ?>
  <li><a href="<?=$site_url?>/<?=$link_data['site_pages_link']?>.html">
    <?=$link_data['site_pages_name']?>
    </a></li>
  <? } ?>
  <? } ?>
   <li><a href="<?=$site_url?>/webmail" target="_blank">Webmail Login</a></li>
  <?php if($compDATA['admin_flipbook_option']=='Yes'){ ?>
  <li><a href="<?=$site_url?>/flip-book/FlipBook.html" target="_blank">FilpBook</a></li>
  <? } ?>
</ul>
<? } ?>