<%@ page language="java" %> <%@ page import="java.util.*" %> <%@ page import="java.sql.*" %> <%@ page import="java.io.*" %> <%@ page import="tripindya.constants.*" %> <%@ page import="tripindya.util.*" %> <% Connection con=null; Statement stmt=null; PreparedStatement pstmt=null; ResultSet rs1=null; //////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////// %> Spiritual Tours | spiritual Tours India | India Spiritual Tours | Spiritual Tour | Spiritual Tour To India | India Spiritual Tour
cheap airfare agents india
Hotels In India, Travel Agent In India, Hotel Reservation In India, Hotel Booking In India, Tour Packages of India, Vacation In India.
Honeymoon destinations agent
Spiritual trip in india, Spiritual tour packages, yoga spiritual travel, Spiritual tours of india, spiritual india travel, Spiritual with Golden Triangle, Rajasthan Spiritual Tour, Goa Spiritual Tour
A Trip To Indya Packages
 
Home
Rajasthan Tour
Kerala Tour
Golden Triangle
Adventure Tour
Ayurveda & Spa
Spiritual Tour

Incentive &

Conferences

Beach Tour
India Train Tour
Wildlife Tour
Culture Tour
Goa Tour
Leh Ladakh Tour
Eastern Himalayas
Book a Tour
Hotel Booking
Contact Us
Email Us
 
Yoga Holiday Travel Packages vacation packages agent guide cheap Flight tickets agency
honeymoon vacation packages india
air india travel tickets agents Ayurveda day trips tour packages romantic holidays getaways destinations breaks
 

 

 

Char Dham Yatra

Religious Tour

Red-fort, New Delhi Tour and Travel in India, India Travel Tour, India Tour Travel


South India Temple Tour


Vaishno Devi Tour


Pilgrimage Tour


Temples Tour in India

Buddha Tour

 
<%@ include file="../jsp/clientSearch.jsp" %>
 
<% int city_id=0; String city_name=null; //String city=null; try { con = DBConnection.getConnect(); //String SqlHotelSearch = "select city.city_name from city,hotel_information where city.city_name=hotel_information.city_name order by city.city_name"; //String SqlHotelSearch = "select city.city_name,city.city_id from city where exists (select hotel_information.city_name,hotel_information.hotel_id from hotel_information where city.city_name=hotel_information.city_name) order by city.city_name"; String SqlHotelSearch = "SELECT DISTINCT hotel_id, city_name FROM hotel_information GROUP BY city_name ORDER BY city_name LIMIT 0,20"; pstmt = con.prepareStatement(SqlHotelSearch); //pstmt.setString(2,city); rs1 = pstmt.executeQuery(); if(!rs1.next()) { out.println("

"); out.println("
"); out.println(""); out.println("

No Hotel found for this search criteria.

"); } else { do { city_name = rs1.getString("city_name"); //city_id = rs1.getInt("city_id"); %> <%=city_name%> | <% // } // end of if valid_type 1,2,3 }while(rs1.next()); // end of while } // end odf else } catch(Exception e) { out.println("Exception Occurred......."); out.println(e.getMessage()); } finally { DBConnection.closeResources(con,rs1,pstmt,null); } %>
 
Online International
Flights Booking
 
Incentive & Conferences

India is a great location for a corporate meeting, incentive trip, venue to hold a business conference ..
and More

 

About Us | Currency Converter | Send Enquiry | India Major Cities | Contact Us | Query | Sitemap | Email

 
Sai Baba Tour, Shirdi Spiritual Tour, Ganga Spiritual Tour, Vasino Devi Yatra, Vesino Devi Tour, Pilgrimage Tour, Pilgrimage In India, India Pilgrimage Tour, Temple Tour In India, Buddha Tour
Copyright@ Frank Hospitalities all right reserved. Website Designed & Maintained by Mind Source
  North India Spiritual Tour, South India Spiritual Tour, Char Dham Yatra, Char Dham India Tour, Amar Nath Yatra, Amar Nath Package, Badrinath Tour, Kedarnath Tour, Buddha Spiritual Tour