BOOKINGS
<%
String trnid="";
String trndate="";
String Name="";
String Address="";
String city="";
String email="";
String contact="";
String roomtype="";
String persons="";
String fromdt="";
String todt="";
String rooms="";
%>
From |
To |
|
Room Type |
Persons |
Name |
Address |
City |
<%
rs=st.executeQuery("SELECT * FROM BookEnqiry WHERE Status=1 ORDER BY trndate DESC");
while(rs.next())
{
trnid=rs.getString("trnid");
trndate=rs.getString("trndate");
Name=rs.getString("Name");
Address=rs.getString("Address");
city=rs.getString("city");
email=rs.getString("email");
contact=rs.getString("contact");
roomtype=rs.getString("roomtype");
persons=rs.getString("persons");
fromdt=rs.getString("fromdt");
todt=rs.getString("todt");
rooms=rs.getString("rooms");
%>
<%=fromdt.substring(0,11)%> |
<%=todt.substring(0,11)%> |
<%=rooms%>
|
<%=roomtype%> |
<%=persons%> |
<%=Name%> |
<%=Address%> |
<%=city%> |
<%
}
rs.close();
st.close();
con.close();
%>