|
| |
 |
|
| |
|
We at Sundoo Industries, manufacturer and supplier of Bits, Bridles, Chaps, Ear Nets, Farrier Tools, Grooming Scissors, Halters, Hoof Knives, Riding Gloves, Rugs, Saddles, Saddle pads, Spurs, Stirrup Iron, Stirrup Leather, Girth, Veterinary Instruments, Combs, Saddle and Bridle Racks.
We have successfully supplied the high quality products to Denmark, Norway, Sweden, Germany, UK, New Zealand, Australia, USA and Canada. All the products illustrated in this web site are the manifestation of remarkable productive skill and technology constituting the blend of most innovation to the highest standard in the choice of material and the methods of sustained working in terms of professionalism.
|
|
|
|
|
 |
|
<%
rs.open "select * from tbl_prods where isnew='y' order by ranking",cn,3,1
if not rs.eof then
while not rs.eof
%>
<%
n=1
while not rs.eof and n<=3
%>
" style="display:none;">
<%
MsecID = request("MsecID")
SecID = request("SecID")
pid = request("pid")
'rs3.open "select * from tbl_mainsection where MainsectionID="&MsecID&" order by ranking",cn,3,1
'if not rs.eof then
' mname = rs3("Mainsectionname")
'end if
'rs3.close
rs3.open "select * from tbl_prods where pid="&rs("pid")&" order by ranking",cn,3,1
if not rs3.eof then
lpic = rs3("simg")
ano = rs3("ano")
pname = rs3("pname")
des = rs3("Description")
end if
rs3.close
%>
|
<%=pname%>
Item #<%=ano%> |
Product Information:
- <%=replace(des,vbcrlf,"
")%>
|
Size Available :
<%
rs1.open "select * from qry_sizes where pid="&rs("pid")&"",cn,3,1
if not rs1.eof then
while not rs1.eof
response.Write(rs1("sizename") & ", ")
rs1.movenext
wend
end if
rs1.close
%> |
|
|
To request a price quote on this item click the
“Add To Basket ” button |
| |
|
|
|
|
<%
n=n+1
rs.movenext
wend
%>
<%
wend
end if
rs.close
%>
|
| |
|
|
|
|
<%
rs.open "select * from tbl_prods where isFeatured='y' order by ranking",cn,3,1
if not rs.eof then
while not rs.eof
%>
<%
r=1
while not rs.eof and r<=4
%>
" style="display:none;">
<%
MsecID = request("MsecID")
SecID = request("SecID")
pid = request("pid")
'rs3.open "select * from tbl_mainsection where MainsectionID="&MsecID&" order by ranking",cn,3,1
'if not rs.eof then
' mname = rs3("Mainsectionname")
'end if
'rs3.close
rs3.open "select * from tbl_prods where pid="&rs("pid")&" order by ranking",cn,3,1
if not rs3.eof then
lpic = rs3("simg")
ano = rs3("ano")
pname = rs3("pname")
des = rs3("Description")
end if
rs3.close
%>
|
<%=pname%>
Item #<%=ano%> |
Product Information:
- <%=replace(des,vbcrlf,"
")%>
|
Size Available :
<%
rs1.open "select * from qry_sizes where pid="&rs("pid")&"",cn,3,1
if not rs1.eof then
while not rs1.eof
response.Write(rs1("sizename") & ", ")
rs1.movenext
wend
end if
rs1.close
%> |
|
|
To request a price quote on this item click the
“Add To Basket ” button |
| |
|
|
|
|
<%if r<>4 then%>
|
<%end if%>
| |
<%if r<>4 then%>
|
<%end if%>
|
<%
r=r+1
rs.movenext
wend
%>
<%
wend
end if
rs.close
%>
|
|
|
|
|
|
|
|
|
|
|
