[ÇóÖú]Êý¾Ý²éѯ

½ÖÍ·°ÔÍõÒ¯

ÎÒ ÔÚ×öÍøÕ¾µÄʱºò,ÎÒÒªÓõ½Á½¸ö±í
id bigclass (bigclass)
1
2
id title pic bigclass (leibie)
°¡ 1
µÄ 1
¶î 2
Ëù 2
ÎÒÒªÏÔʾbigclassÀïµÄbigclassºÍleibieÀïµÄpic
Èç
1 °¡ µÄ
2 ¶î Ëù

ÓÇÓôÏÀ¿Í

ǶÌ×Ñ­»·¡£¡£¡£¡£

set rs = server.createobject("adodb.recordset")
sql="select * from bigclass order by id asc"
rs.open sql,conn,1,1
do while not rs.eof
response.write(rs("bigclass"))
set rs1 = server.createobject("adodb.recordset")
sql1 = "select * from leibie where bigclass="&rs("bigclass")
rs1.open sql1,conn,1,1
do while not rs1.eof
response.write(rs1("pic")&"&nbsp")
rs1.movenext
loop
rs1.close
set rs1 = nothing
rs.movenext
loop
rs.close
set rs = nothing