sort_small_class.asp

来自「非常有商业价值的软件」· ASP 代码 · 共 42 行

<%
id=my_request("id",1)
sid=my_request("sid",1)
flag=my_request("flag",1)
sql="select txt_big_class from big_class where id="&id
set rs=conn.execute (sql)
txt_big_class=rs("txt_big_class")
rs.close
set rs=nothing
sql="select txt_small_class from small_class where id="&sid
set rs=conn.execute (sql)
txt_small_class=rs("txt_small_class")
rs.close
set rs=nothing
set rss=conn.execute("select count(id) as num from yqj_product where sid="&sid)
count=rss("num")
rss.close
Set rss=nothing
response.write "<table width=631 border=0 cellspacing=0 cellpadding=0>"
response.write "<tr>"
response.write "<td height=31 valign=top bgcolor=#B4B4B4>"
response.write "<table border=0 width=100% cellspacing=0 cellpadding=0 height=22>"
response.write "<tr>"
response.write "<td bgcolor=#FFFFFF class=sort valign=middle>"
response.write "当前类别>>>"
response.write "<a href=list.asp?id="&id&">"
response.write txt_big_class
response.write "</a>"
response.write ">>>"
response.write "<a href=list_sort.asp?id="&id&"&sid="&sid&">"
response.write txt_small_class
response.write "</a>"
response.write "</td>"
response.write "</tr>"
response.write "</table>"
response.write "</td>"
response.write "</tr>"
response.write "</table>"
rs.close
set rs=nothing
%>