%
if request.QueryString("id")="" then
response.Redirect("index.asp")
else
if Iszs(request.QueryString("id"))=false then
response.Redirect("index.asp")
end if
end if
'分类类别
set tp=server.CreateObject("adodb.recordset")
sql="select * from mtp where m_id="&request.QueryString("id")&""
tp.open sql,coon,1,3
if tp.eof then
response.Redirect("index.asp")
end if
'下属类别
set stp=server.CreateObject("adodb.recordset")
sql="select * from mtp where b_id="&request.QueryString("id")&" order by num asc"
stp.open sql,coon,1,3
%>
<%
set fg=server.CreateObject("adodb.recordset")
sql="select top 10 * from muban where len(pic)>3 and m_id in(select m_id from mtp where b_id="&request.QueryString("id")&") order by id desc"
fg.open sql,coon,1,3
if fg.eof=false then
for i=1 to fg.recordcount
%>
">" alt="<%=left(fg("name"),20)%>" width="305" height="255" />
<%
fg.movenext
if fg.eof then exit for
next
end if
fg.close
%>
<%
set wz=nothing
set wz=server.CreateObject("adodb.recordset")
sql="select top 8 * from muban where m_id in(select m_id from mtp where b_id="&request.QueryString("id")&")order by id desc"
wz.open sql,coon,1,3
if wz.eof=false then
for j=1 to wz.recordcount
%>
<%
if (i+1) mod 3 <>0 then
set t1=nothing
set t1=server.CreateObject("adodb.recordset")
sql="select top 1 * from muban where tj<>0 and len(pic)>3 and m_id="&stp("m_id")&""
t1.open sql,coon,1,3
if t1.eof=false then
%>
<%
set wz=nothing
set wz=server.CreateObject("adodb.recordset")
sql="select * from muban where m_id="&stp("m_id")&" order by id desc"
wz.open sql,coon,1,3
if wz.eof=false then
for j=1 to wz.recordcount
%>