¼±°¡¡«Ç°±²°ï¸öæ

¦á¨ã˧¡©¦ð`

<!--#include file="conn.asp"-->
<%
set rs2=server.createobject("adodb.recordset")
set rs=server.createobject("adodb.recordset")
type_id=request.querystring("type_id")
if type_id="" then
sql="select top 1 type_id from classes"
rs.open sql,conn,1,1
if not(rs.eof and rs.bof) then
type_id=rs("type_id")
else
response.write("ÇëÌí¼Ó²úÆ·´óÀà")
response.end
end if
rs.close
else
type_id=replace(type_id,"_","&")
end if
%>
.........
<%sql="select * from products where type_id='"&rs("type_id")&"' order by product_date desc"
rs2.open sql,conn,1,1
rdcount2=rs2.recordcount
for k=1 to rdcount2
%>
<%
if rs2("class_id")<>"" then
%>
<TR>
<TD width="22">
<p align="center">
<IMG
src="images/arrow_blk.gif"
border=0 align="right"></TD>
<TD><A class=navsublinks href="prod.asp?type_id=<%=replace(rs2("type_id"),"&","_")%>"><%=rs2("class_id")%></A></TD></TR>
<%
else
%>
<%
end if
%>
<%rs2.movenext
next
rs2.close
%>
..........................
Óõ½µÄÊý¾Ý¿â×Ö¶ÎÓÐ
product_id ²úÆ·±àºÅ ×Ô¶¯
type_id ´óÀàÃû³Æ Îı¾
class_id СÀàÃû³Æ Îı¾
ÇëÇ°±²Ö¸µã
1¡£ÈçºÎÐ޸ĺìÉ«µÄsql²éѯÓï¾ä£¬²ÅÄÜÈÃÏÂÃæµÄ rs2("class_id") ²»Öظ´
2¡£ÈçºÎÐÞ¸ÄÀ¶É«µÄÁ´½Ó²ÎÊý£¬Ê¹µÃ£¬Á´½Óµ½µÄÒ³ÃæÖ»ÏÔʾ¸Ãclass_id£¨Ð¡ÀࣩµÄ²úÆ·
СµÜÊdzõѧÕߣ¬Èç¹ûÇ°±²ÄÜ°ïæ¸Äһϣ¬Ð¡µÜ¸Ð¼¤²»¾¡
лл

ºÚÏÀ

ûÈËÀí£¿

È˽ܵØÁé

Ö÷Òª²»ÖªµÀÄãÔÚ˵ʲô¡£¡£¡£

°®Äã

select DISTINCT(class_id) * from products where type_id='"&rs("type_id")&"' order by product_date desc
Â¥Ö÷¿ÉÒÔ¼Óºì×ֵĵط½ÊÔÊÔ¿´¡£

²Ôñ·

²»ÐУ¬sqlÓï¾ä±¨´í