|
<% getHeading "", "hdnews", "inthenews" %>
[an error occurred while processing this directive] |
|
| <% getHeading "", "hdcat", "" %> |
|
| <%=showlevels(catid, shopurl & "shop/category.asp")%> |
|
<%
'Open database get sub categories.
set rs=opendb("SELECT * FROM category WHERE subof=" & catid & " ORDER BY name")
if not rs.eof then
%>Also see:<%
rs.movefirst
while not rs.eof
subcatname=rs("name")
subcatid=rs("id")
%> category.asp?catid=<%=subcatid%>">
<%=subcatname%> <%
rs.movenext
if not rs.eof then
response.write (" | ")
end if
wend
end if
rs.close
set rs=nothing
%> |
|
|
<%
'Open database get items from category.
set rs=opendb("SELECT * FROM items WHERE catid=" & catid & " AND active='Yes' ORDER BY " & sortby)
if not rs.eof then
rs.movefirst
rs.pagesize = numperpage
totalpages = rs.pagecount
rs.absolutepage = currentpage
end if
if not rs.eof then
%>
| <% getHeading "", "hdcatitems", "" %> |
|
|
|
<%
do while not rs.eof and count < rs.pagesize
itemname=rs("name")
price=rs("price")
hideprice=rs("hideprice")
if hideprice="ON" then
hideprice=1
else
hideprice=0
end if
saleprice=rs("saleprice")
onsale=rs("onsale")
tempimage=rs("smallimage")
description=rs("description")
shortdesc=rs("shortdesc")
itemno=rs("itemno")
imagefound=""
if Len(tempimage)>0 then
smallimage=tempimage
else
imagefound="no"
end if
%>
<%
'Determine whether to display image.
if imagefound="no" then
else
%>">
<%end if%> |
"><%=itemname%>
<%=shortdesc%> [">more] |
|
<%=left(itemno,8)%> |
<%
if hideprice=0 then
'Display price or sale price?
if onsale="Yes" or onsale="yes" then
%> <% =showCurr(price)%>
<% =showCurr(saleprice)%> <%
else
response.write(showCurr(price))
end if
end if
%> |
|
<%
rs.movenext
count = count + 1
loop
%>
| Displaying Page <%=currentpage%> of
<%=totalpages%>. |
<%
'Create Previous Page link.
if not currentpage = 1 Then
%>
| <% showbutton " Previous " & maxrec,"javascript:(document.prev.submit())","" %>
|
<%
end if
'Create Next Page link.
if not currentpage = totalpages then
%>
<% showbutton " Next ","","next" %>
|
<%
end if
%>
|
| (To sort
items, click on the heading) |
<%
end if
rs.close
set rs=nothing
%>
|
|
|
|