|
 |
|
 |
<%
String exec_sql = "select (count(tag) + 1) nr from menu_main where lang = '" + lang + "' and m_status = 'Y' and m_menu = 'L' ";
StatementInfo = ConnInfo.prepareStatement(exec_sql);
Info = StatementInfo.executeQuery();
Info_hasData = Info.next();
String nr_row = Info.getString("nr");
Info.close();
StatementInfo.close();
StatementInfo = ConnInfo.prepareStatement("select tag, img, link from menu_main where lang = '" + lang + "' and m_status = 'Y' and m_menu = 'L' order by m_order");
Info = StatementInfo.executeQuery();
Info_hasData = Info.next();
i = 1;
while ( Info_hasData ) {
if ( i == 1 ) {
%>
| |
<% }
else {
%>
<% } %>
" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('<%=Info.getString("img")%>_img','','Images/<%=Info.getString("img")%>_ovr.gif',1)"> _act.gif" name="<%=Info.getString("img")%>_img" width="136" height="26" border="0"> |
<% if ( i == 1 ) {
%>
|
<% }
else {
%>
<% }
// sub menu
if ( i == 2 ) {
%>
|
|
|
<%
StatementSubInfo = ConnInfo.prepareStatement("select tag, link from menu_det where lang = '" + lang + "' and code_main_menu = '2' and s_status = 'Y' and s_order <> 0 order by s_order");
SubInfo = StatementSubInfo.executeQuery();
SubInfo_hasData = SubInfo.next();
while ( SubInfo_hasData ) {
%>
|
" target="_self" class="link6"><%=SubInfo.getString("tag") %> |
|
|
<% SubInfo_hasData = SubInfo.next();
}
SubInfo.close();
StatementSubInfo.close();
%>
|
|
|
<%
}
i = i + 1;
Info_hasData = Info.next();
}
Info.close();
StatementInfo.close();
%>
 |
|
|
|
|
|
.......................
Loading
.......................
|
<%
StatementPromNews = ConnInfo.prepareStatement("select dailytour.*, dailytour_type.tag dtt_disp, travel_type.tag tt_disp from dailytour, dailytour_type, travel_type where dailytour.dtt_id = dailytour_type.dtt_id and dailytour.tt_id = travel_type.tt_id and dailytour.lang = '" + lang + "' and dailytour.dailytour_id = " + request.getParameter("mi") + " ");
PromNews = StatementPromNews.executeQuery();
PromNews_hasData = PromNews.next();
while ( PromNews_hasData ) {
%>
 |
|
<%=(((Info_data = PromNews.getObject("title"))==null || PromNews.wasNull())?"":Info_data)%>
|
|
|
|
No. of Days:<%=(((Info_data = PromNews.getObject("day_no"))==null || PromNews.wasNull())?"":Info_data)%>
No. of Nights:<%=(((Info_data = PromNews.getObject("night_no"))==null || PromNews.wasNull())?"":Info_data)%>
<%=(((Info_data = PromNews.getObject("dtt_disp"))==null || PromNews.wasNull())?"":Info_data)%>
Price: <%=(((Info_data = PromNews.getObject("price"))==null || PromNews.wasNull())?"":Info_data)%> €
|
 " border="0"> |
|
Included in price:
<%=(((Info_data = PromNews.getObject("included"))==null || PromNews.wasNull())?"":Info_data)%>
Not Included in price:
<%=(((Info_data = PromNews.getObject("nonincluded"))==null || PromNews.wasNull())?"":Info_data)%>
|
|
|
|
<%=(((Info_data = PromNews.getObject("more_info"))==null || PromNews.wasNull())?"":Info_data)%> |
|
|
|
|
|
 |
<% PromNews_hasData = PromNews.next();
}
PromNews.close();
StatementPromNews.close();
%>
|
|
|
|
|
<%
StatementSubInfo = ConnInfo.prepareStatement("select * from reklama where r_status = 'T' and r_priority = 'P'");
SubInfo = StatementSubInfo.executeQuery();
SubInfo_hasData = SubInfo.next();
while ( SubInfo_hasData ) {
%>
<%=(((Info_data = SubInfo.getObject("info"))==null || SubInfo.wasNull())?"":Info_data)%>
<% SubInfo_hasData = SubInfo.next();
}
SubInfo.close();
StatementSubInfo.close();
%>
|
|
|
|
|
|
|