<%
sqlstr = "select a.*,b.cate_name from ansh_product a, ansh_categories b where a.cate_id = " & request.querystring("cateid")&" and a.cate_id = b. cate_id and a.presence = 'Active' order by prod_name "
'response.write sqlstr
if rs.state=1 then rs.close
rs.open sqlstr,myconn,3,3
if rs.recordcount = 0 then
%>
| Products Listed in this category |
<%
else
%>
| Product
Range -> COMMUNICATION ENGINNERING |
| Name |
Download
pdf |
Tender Specifiction |
<%
rowcount = 1
while not rs.eof
if rowcount mod 2 = 0 then
bgcolor = "#dddddd"
else
bgcolor="#ffffff"
end if
%>
|
Communication System Trainer (Model: XPO-COM) |
|
 ">
-- |
<%
rowcount = rowcount + 1
rs.movenext
wend
%>
|
|
Fiber Optic Communication Trainer |
 "> -- |
 "> -- |
| |
Click
on the name of view brief description
or
Click on the pdf icon to download the pdf file of the the product |
<%
end if
%>
|