<table align="left" cellpadding="0" cellspace="0" border="0">
<tr>
<td id="www_qpsh_com1" valign="top"><%
ID=27
if ID="" or not IsNumeric(ID) then
response.write "<center>暂无相关信息</center>"
elseif conn.execute("select * from Qianbo_Products Where ViewFlag and SortID="&ID).eof then
response.write "<center>暂无相关信息</center>"
else
dim rs4,sql4
set rs4 = server.createobject("adodb.recordset")
sql4="select top 6 * from Qianbo_Products where ViewFlag and SortID in (23,27) order by id desc"
rs4.open sql4,conn,1,3
End If
while not rs4.eof or rs4.bof%>
<table width="138" border="0" cellspacing="0" cellpadding="0" align="left" style="margin:5px; border:1px solid #CCC;">
<tr>
------------------------------------------------------------------------------------------------
<td valign="top"><img src='b/<%=rs4("SmallPic")%>' width="138" height="155" alt="<%=rs4("ProductName")%>" /></td>
-------------------------------------------------------------------------------------------------
</tr>
<tr>
<td valign="bottom" align="center" height="22px"><a href="ProductView.asp?ID=<%=rs4("id")%>&sortID=<%=rs4("SortID")%>" class="navred" style="font-size:12px; "><%=rs4("ProductName")%></a></td>
</tr>
</table>
<% rs4.movenext
wend