<?php
function getDropDown($parentId){
	$query	=	"SELECT * FROM `tbl_static_pages` WHERE `parentId` = ".$parentId." AND `enable` = 'Activate'";
	$result	=	mysql_query($query) OR DIE(mysql_error());
	$count	=	mysql_num_rows($result);
	if($count > 0){
		echo "<ul>";
		while($row	=	mysql_fetch_assoc($result)){
			if($row['linkType'] == 'desc'){
				echo "<li><a href='static.php?pageId=".$row['staticId']."'>".$row['staticTitle']."</a>";
				getDropDown($row['staticId']);			
				echo "</li>";
			}
			else{
				echo "<li><a href='".$row['externalLink']."'>".$row['staticTitle']."</a>";
				getDropDown($row['staticId']);			
				echo "</li>";
			}
		}
		echo "</ul>";
	}
}
?>
<!--navigation Count Start Here-->
<div class="NavCount fl">
	<!--Navigation Count Start-->
	<div class="navigationNew fl">
		<ul id="MenuBar1" class="MenuBarHorizontal">
			<li><a href="home.php">Home</a></li>
			<li><a href="about_us.php">About Us</a>
				<?php echo getDropDown(2); ?>
			</li>
			<li><a href="products.php">PRODUCTS</a>
				<?php echo getDropDown(3); ?>
			</li>
			<li><a href="mpd.php">Milk Procurement</a>
				<?php echo getDropDown(4); ?>
			</li>
			<li><a  href="#">B2B</a>
				<?php echo getDropDown(5); ?>
			</li>
			<!-- <li><a  href="b2b.php">B2B</a>
				<?php //echo getDropDown(5); ?>
			</li> 
			<li><a href="research.php">R & D</a>
				<?php //echo getDropDown(6); ?>
			</li>-->
			<li><a  href="media.php">Media</a></li>			
			<li style="background-image:none!Important;"><a href="contact_us.php" style="padding-right:0px!Important;">Contact Us</a>
				<?php echo getDropDown(7); ?>
			</li>
		</ul>
	</div>
	<!--Navigation Count End-->
</div>
<!--navigation Count End Here-->