¶à±í²éѯµÄʱºòÈçºÎÏÔʾ¶à¸ö×Ö¶Î?

o.¹TÜëÝÔó줭

ÔÚÏÂÃæµÄ´úÂëÖÐÔõÑùÈÃËüÏÔʾ¶à¸ö×ֶεÄÖµ?±ÈÈ绹ÓÐclass_1.nameÖ®ÀàµÄ.
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<%set rs=server.CreateObject("adodb.recordset")
sql="select count(product.category_id) as name from product inner join class_1 on product.category_id=class_1.id where class_1.id=404"
[֪ʶÎÊ´ð¦Ø¦Ø¦Ø.¦ÖiuGoo.§ãom]
'do while not rs.eof
rs.open sql,conn,1,1%>
<tr>

<td><%=rs("name")%></td>

</tr>
<%
rs.movenext
' loop

rs.close
set rs=nothing%>

£óee£Ùa

select count(product.category_id) as name2,class_1.name from product inner join class_1 on product.category_id=class_1.id where class_1.id=404

ÊÔÏÂ