[求助]调用同类产品的代码是否正确?
我想实现在一个产品页显示同类产品的功能,帮我看看这段代码是否正确,该怎么改,谢谢!<table width="100%" border="0" cellspacing="0" cellpadding="0">
<%
Set rs=Server.CreateObject("ADODB.RecordSet")
sql="select * from Product where BigClassName='"&BigClassName&"' order by id desc"
rs.Open sql,conn,1,1
if rs.eof and rs.bof then
response.Write("暂时没有记录")
else
%>
<tr>
<td align="center">
<TABLE cellSpacing=0 cellPadding=0 width="130" border=0>
<TBODY>
<tr><td height="110" width="130" colspan="2" align="center">
<A HREF='ProductShow.asp?ArticleID= <%=rs("articleid")%>'>
<IMG SRC=<%=rs("DefaultPicUrl")%> BORDER=0 width="122" height="104"></A></td></tr>
<TR align="center">
<TD colSpan=2><table width="90%" border="0" cellspacing="1" cellpadding="1">
<tr>
<td align="center"><%=rs("title")%></td>
</tr>
</table></TD>
</TR>
<TR align="center" height=20>
<TD colspan="2"><table width="100%" border="0" cellspacing="1" cellpadding="1">
</table></TD>
</TR>
</TBODY>
</TABLE></td>
</tr>
<%
end if
rs.close
set rs=nothing
%>
</table>