asp高手救命呀!进来帮我改下代码好吗?

来源:百度知道 编辑:UC知道 时间:2024/06/29 02:00:37
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="143" valign="top">
<%
sql="select top 6 * from shop_product where btype_id = (select btype_id from shop_product where productid = "&request("id")&") order by productid desc "
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,1,1
%>
<table width="100%" height="29" border="0" cellpadding="0" cellspacing="0">
<tr>
<td class="style4"><img src="img/xiao/view_r_title1.gif" width="191" height="29"></td>

<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="143" valign="top">
<%
sql="select top 6 * from shop_product where btype_id = (select btype_id from shop_product where productid = "&request("id")&") order by productid desc "
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,1,1
%>
<table width="100%" height="29" border="0" cellpadding="0" cellspacing="0">
<tr>
<td class="style4"><img src="img/xiao/view_r_title1.gif" width="191" height="29"></td>
</tr>
</table>
<br>

<table width=100% align=center>
<tr>
<%
i=0
do while not rs.eof
i=i+1
%>
<