 |
 |
| Look below for some great deals |
|
<%
sql="select * from cdcat"
mycmd.commandtext=sql
set rscat=mycmd.execute
if rscat.recordcount>0 then
%>
<%
rowCount=0
while not rscat.eof
%>
<% if rowcount mod 2=0 then %><% end if %>
| " class="red18BOLD"><%=rscat("catname")%> |
<% if rowcount mod 2=1 then %> <% end if %>
<%
rowCount=rowCount+1
rscat.movenext
wend
end if
rscat.close
if rowcount mod 2=1 then %> | <% end if %>
<%
sql="select a.catid,a.catname,(select count(b.offerid) from mstoffer b where b.catid=a.catid) as co from cdcat a"
mycmd.commandtext=sql
set rscat=mycmd.execute
while not rscat.eof
if rscat("co")>0 then
%>
| <%=rscat("catname")%>"> |
|
<%
sql="select a.*,b.catname,c.otype from mstoffer a,cdcat b,cdotype c where a.catid=b.catid and a.otypeid=c.otypeid and a.catid=" & rscat("catid")
mycmd.commandtext=sql
set rsoffer=mycmd.execute
while not rsoffer.eof
%>
|
<%=rsoffer("otitle")%>
|
 starsm.gif" height="15" hspace="0" vspace="0" align="default"> |
|
|
|
<%=rsoffer("onight") %> nights
|
<%=rsoffer("otype")%> |
<%=rsoffer("oroom")%> |
|
|
|
 " width="100" height="100" alt="<%=imgalt %>">
|
<%=rsoffer("oprice")%>
|
<%=rsoffer("odesc")%>
|
|
|
|
<%
rsoffer.movenext
wend
%>
<%
end if
rscat.movenext
wend
rscat.close
%>
| For More Special Offers Call... 0845 074 0066 |
|
|
|
|
|
|
