<?php 
	include("connection.php");
?>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
 <head>
  <title>Hotels in rishikesh | Resorts in rishikesh | Places near haridwar</title>
<meta name="Description" content="The Haridwar resort has a designed menu to elicit utmost relaxation and gratification in Rishikesh hotels, we can also develop customised packages based on personal requirements near Places near haridwar.">
<meta name="Keywords" content="Places near haridwar, Resorts in rishikesh, Rishikesh hotel, Rishkesh resorts, Hotel in rishikesh, Hotels in rishikesh, Resorts in haridwar, hotels near haridwar, Rishikesh hotels, Haridwar resorts">
 <script type="text/javascript" src="menu.js"></script>
  <link href="style.css" rel="stylesheet" type="text/css" />
  <link href="text.css" rel="stylesheet" type="text/css" />

<script type="text/javascript" src="script/validation.js"></script>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<script type="text/javascript">
<!--
function MM_preloadImages() { //v3.0
  var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
    var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
    if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}
//-->
</script>
</head>
<BODY onLoad="MM_preloadImages('images/pac01.png','images/pac02.png','images/pac03.png','images/pac04.png','images/pac05.png','images/pac06.png','images/pac07.png','images/pac08.png')">

<div style="position: absolute; z-index: 1; width: 100%; height: auto;"><img id="full-screen-background-image" src="images/bg_packages.jpg" alt="full screen background image" /></div>
 
<div style="position:relative; width:100%; height:40px; top:0px; left:0px; z-index:2">            
            <div id="menu1" style="position:absolute; width:100%; height:24px; top:0px; left:0px; z-index:9; background:#3b587a; color:#FFFFFF;background-color: #000; filter:alpha(opacity=80); opacity:.8;"
            onmouseover="displayPanel1()"; onMouseOut="nodisplayPanel1();">													
			<div style="position:absolute; width:911px; height:20px; top:3px; left:18%;"><a href="aboutus.html" >About Us</a></div>
			<div class="head" style="position:absolute; width:827px; height:26px; top:3px; left:27%;">Facilities</div>
			<div class="head" style="position:absolute; width:754px; height:26px; top:3px; left:36%;">Experiences</div>
			<div style="position:absolute; width:650px; height:20px; top:3px; left:46%;">Offers/Packages</div>
			<div class="head" style="position:absolute; width:397px; height:20px; top:3px; left:58%;">Media Gallery</div>
			<div style="position:absolute; width:281px; height:20px; top:3px; left:68%;">Book Now</a></div>
			<div style="position:absolute; width:168px; height:20px; top:3px; left:77%;">  Contact Us</a>			
			</div>
            </div>     
            </div>  

			<div id="menu2" style="display:none; position:absolute; width:100%; height:195px; top:24px; z-index:8; background:#3b587a; color:#FFFFFF; background-color: #000; filter:alpha(opacity=70); opacity:.7;" onMouseOver="displayPanel1()"; onMouseOut="nodisplayPanel1();">

			<div style="position:absolute; width:315px; height:20px; top:10px; left:27%; color:rgb(45,112,165)"><a href="facilites_dining.html" >Dining</a></div>
            <div style="position:absolute; width:315px; height:20px; top:30px; left:27%;"><a href="facilites_corporate.html" >Corporate</a></div>
            <div style="position:absolute; width:315px; height:20px; top:50px; left:27%;"><a href="facilites_weddings.html" >Weddings</a></div>
            <div style="position:absolute; width:315px; height:20px; top:70px; left:27%;"><a href="facilites_accomodation.html" >Accomodation</a></div>
            <div style="position:absolute; width:315px; height:20px; top:10px; left:36%;"><a href="experiences_yoga.html" >Yoga</a></div>
		    <div style="position:absolute; width:315px; height:20px; top:30px; left:36%;"><a href="experiences_ayurvedicspa.html" >Ayurvedic Spa</a></div>
            <div style="position:absolute; width:315px; height:20px; top:50px; left:36%;"><a href="experiences_rafting.html" >White Water Rafting</a></div>
            <div style="position:absolute; width:315px; height:20px; top:70px; left:36%;"><a href="experiences_safari.html" >Safari</a></div>
			<div style="position:absolute; width:315px; height:20px; top:90px; left:36%;"><a href="experiences_trekking.html" >Trekking</a></div>
            <div style="position:absolute; width:315px; height:20px; top:110px; left:36%;color:rgb(45,112,165)"><a href="experiences_biking.html" >Biking</a>            </div>
            <div style="position:absolute; width:315px; height:20px; top:130px; left:36%;"><a href="experiences_boating.html" >Boating</a></div>
			<div style="position:absolute; width:315px; height:20px; top:150px; left:36%;"><a href="experiences_pilgrimage.html" >Pilgrimage</a></div>
            <div style="position:absolute; width:315px; height:20px; top:170px; left:36%;"><a href="experiences_birdwatching.html" >Bird watching</a></div>
            <div style="position:absolute; width:315px; height:20px; top:10px; left:58%;"><a href="hotelrishikeshgangakinarehotel360degreeview.html" >360&deg;</a></div>	
            <div style="position:absolute; width:315px; height:20px; top:30px; left:58%;"><a href="picturegallery.html" >Picture Gallery</a></div>	
            <div style="position:absolute; width:281px; height:20px; top:10px; left:68%;"><a href="ganga_kinare_room_booking.php" >Rooms</a></div>
            <div style="position:absolute; width:281px; height:20px; top:30px; left:68%;"><a href="ganga_kinare_package_booking.php" >Packages</a></div>
            <div style="position:absolute; width:168px; height:20px; top:10px; left:77%;"><a href="contact@ganaga_kinare.html" > Contact Info. </a></div>
            <div style="position:absolute; width:168px; height:20px; top:30px; left:77%;"><a href="helpdesk_ganaga_kinare.php" >  Inquiry </a></div>
              </div>
            </div>			


<div style="position:absolute; z-index:6; width:100%; height:100%;min-width:850px; ">
           <div style= "position:relative; width:80%; height:90%; float:left; top:0px; z-index:5; overflow:auto; min-width:850px; padding-left: 50px; padding-top:30px; ; visibility: visible;">

<form id="packagesandoffers" name="packagesandoffers" method="post">

<table width="121%" height="114%" border="0" align="right" id="body" name="stylized">
  <tr>
    <td height="52" colspan="6"><span class="dbatexts2"><br>
      Experiential Packages<br></span>
      </span><p><span class="dbatext1">The resort offers myriad packages, tailored to cater to varied needs. Whether it is light rejuvenation over a weekend, an elaborate program for deep cleansing and detoxification, or adventure activities, the resort has designed menus to elicit utmost relaxation and gratification. We can also develop customised packages based on personal requirements. Contact us for detailed information and tariffs of packages.   </span></p></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>  
    <td colspan="2" align="right"><a href="http://www.gangakinare.com/blog/?p=314"><img src="images/complementaryincl.jpg" width="199" height="20" border="0"></a>          
    <td colspan="2"><a href="ganga_kinare_room_pictures_booking_control_panel.html"><img src="images/room_pics.jpg" width="199" height="20" border="0"></a>          
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>  
    <td>  
    <td>  
    <td>  
    <td>  
  </tr>
  <tr>
    <td width="40%">Package Name</td>
    <td width="10%">No. of nights</td>  
    <td width="20%">Click to see details</td>
    <td width="10%">Room Category</td>
    <td width="10%">Price per couple</td>
    <td width="10%">&nbsp;</td>
  </tr>

<?php 
	
	$sql = "SELECT occ_num,package_name,price,no_of_days,no_of_person,DATE_FORMAT(from_date,'%D %M %Y %W') from_date1, DATE_FORMAT(to_date,'%D %M %Y %W') to_date, url From packages where date_add(to_date,INTERVAL '23:59' HOUR_MINUTE) >= date_add(now(),INTERVAL '09:30' HOUR_MINUTE) order by occ_num desc";
	
	$packages = $obj->select($sql);
	$cnt=count($packages);
	$res="";


	for($i=0; $i<$cnt; $i++) 
	{
		$occ_num = $packages[$i][0];
		$package_name = $packages[$i][1];
		$price = $packages[$i][2];
		$no_of_days = $packages[$i][3];
		$no_of_adults = $packages[$i][4];
		$fromdate = $packages[$i][5];
		$todate = $packages[$i][6];
		$url = $packages[$i][7];
?>

  <tr>
    <td width="40%"><?php  if(strlen($package_name) > 0) { echo $package_name; } else { echo "&nbsp;"; } ?></td>
    <td width="10%" align="center"> <?php  if(strlen($no_of_days) > 0) { echo $no_of_days; } else { echo "&nbsp;"; } ?></td>  
    <td width="20%"><a href="<?php echo $url?>"><img src="images/clickhere.jpg" width="77" height="20" border="0"></a> </td>           
    <td width="10%">
      <label for="select"></label>
      <select name="roomtype_<?php echo $occ_num?>" class="bodytext" id="roomtype_<?php echo $occ_num?>" onChange="getPackageCharge(<?php echo $occ_num?>)">
	   <option value="-1" selected>-- Select Room Type -- </option>
	   <option value="deluxe_room">Deluxe Room</option>
	   <option value="super_deluxe_room">Super Delux Room</option>
	   <option value="suite">Suite</option>
	   <option value="presidential_suite">Presidential Suite</option>
	 </select>   </td>
	<td width="10%" align="center"><div id="price_<?php echo $occ_num?>"></div></td>
    <td width="10%"><div id="book_now_<?php echo $occ_num?>"><a href="ganga_kinare_package_booking.php?occ_num=<?php echo $occ_num; ?>"><img src="images/booknow.jpg" width="77" height="20" border="0"></a></div></td>    
  </tr>

<?php 
}

 if ($cnt == 0) 
{
	 ?>
			<tr>
			 <td colspan="7" align="middle"><span class="dbatext">No Package Available</span></td>
		   </tr>
	 <?php
}
?>



  <tr>
    <td>&nbsp;</td>
    <td colspan="5">  
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td colspan="5">  
  </tr>
  <tr>
    <td width="242">&nbsp;</td>
    <td colspan="5">    
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td colspan="5"><script language='JavaScript'>
function openLogo(ClientID)
{
var attributes = 'toolbar=0,location=0,directories=0,status=0, menubar=0,scrollbars=1,resizable=1,width=550,height=600,left=0,top=0';
sealWin=window.open("http://www.ccavenue.com/verifySeal.jsp?ClientID='him18765' ,'win','attributes'"); 
self.name = 'mainWin'; 
}
                 </script>
      </th>
      <span class="copyright"> &nbsp;&nbsp;&nbsp;&nbsp;All rights reserved. &copy; Copyright 2012, Himalayan Hotels Pvt. Ltd., powered by</span> <a href="https://www.facebook.com/DemoticStudios" target="_blank"><span class="copyright">Demotic Studios</span></a>    
  </tr>
</table>
</form>
</div></div>

<div style="position: absolute; width: 317px; height: 81px; top: 86%; left: 40%; z-index: 10;"><img src="images/logo.png" border="0" alt="" width="317" height="81" /></div>
<div id="menu4" style="position: absolute; width: 100%; height: 30px; bottom: 0px; left: 0px; z-index: 8; background: #3b587a; color: #ffffff; background-color: #000; filter: alpha(opacity=80); opacity: .8;" onMouseOver="displayPanel2()" onMouseOut="nodisplayPanel2();">
<div style="position: absolute; width: 400px; height: 20px; top: 0px; left: 16%;"><a href="http://www.facebook.com/gangakinare" target="_blank"><img src="images/facebook.png" border="0" alt="" hspace="2" vspace="0" width="30" height="30" align="left" /></a> <a href="http://twitter.com/#!/gangakinare" target="_blank"><img src="images/twitter.png" border="0" alt="" hspace="2" vspace="0" width="30" height="30" align="left" /></a><a href="http://hotelgangakinare.blogspot.com/" target="_blank"><img src="images/blog.png" border="0" alt="" hspace="2" vspace="0" width="30" height="30" align="left" /></a> <a href="http://www.tripadvisor.in/Hotel_Review-g580106-d580692-Reviews-Ganga_Kinare-Rishikesh_Uttarakhand.html" target="_blank"><img src="images/tripadviser.png" border="0" alt="" hspace="2" vspace="0" width="30" height="30" align="left" /></a></div>
<div style="position: absolute; width: 236px; height: 20px; left: 70%; bottom: 6px;"><a href="getting_to_ganga_kinare_hotel.html" target="_blank"><span class="explore"> Getting Here</span></a></div>
<div style="position: absolute; width: 236px; height: 20px; left: 80%; bottom: 6px;"><a href="getting_to_ganga_kinare_hotel.html" target="_blank"><span class="explore"> Explore </span></a></div>
</div>
<div id="menu3" style="display: none; position: absolute; width: 100%; height: 100px; bottom: 30px; z-index: 9; background: #3b587a; color: #ffffff; background-color: #000; filter: alpha(opacity=70); opacity: .7;" onMouseOver="displayPanel2()" onMouseOut="nodisplayPanel2();">
<div style="position: absolute; width: 315px; bottom: 5px; left: 16.7%;"><a href="http://www.facebook.com/gangakinare" target="_blank"><img src="images/fbtext.png" border="0" alt="" hspace="5" align="left" /></a> <a href="http://twitter.com/#!/gangakinare" target="_blank"><img src="images/twittertext.png" border="0" alt="" hspace="6" align="left" /></a> <a href="http://hotelgangakinare.blogspot.com/" target="_blank"><img src="images/blogspot_text.png" border="0" alt="" hspace="6" align="left" /></a> <a href="http://www.tripadvisor.in/Hotel_Review-g580106-d580692-Reviews-Ganga_Kinare-Rishikesh_Uttarakhand.html" target="_blank"><img src="images/tripadvisertext.png" border="0" alt="" hspace="9" align="left" /></a></div>
<div style="position: absolute; width: 315px; bottom: 5px; left: 81.5%;"><a href="getting_to_ganga_kinare_hotel.html" target="_blank"> Rishikesh </a></div>
<div style="position: absolute; width: 315px; bottom: 25px; left: 81.5%;"><a href="getting_to_ganga_kinare_hotel.html" target="_blank"> Haridwar </a></div>
</div>
</body>
</html>