<tr>
<td id="gd"><marquee direction="left" scrollamount="3" scrolldelay="1" οnmοuseοver=this.stop() οnmοuseοut=this.start() border="0" width="960">产品推荐:<%i = 1
Set Rs = conn.execute("Select top 10 * From [pro] where ComID = "&UID&" Order By Orders,PID")
while not rs.eof
if i <> 1 then%> | <%end if%><a href="Show.asp?PID=<%=Rs("PID")%>"><%=Rs("PName")%></a><%Rs.movenext
i = i + 1
wend%></marquee></td>
</tr>
<td id="gd"><marquee direction="left" scrollamount="3" scrolldelay="1" οnmοuseοver=this.stop() οnmοuseοut=this.start() border="0" width="960">产品推荐:<%i = 1
Set Rs = conn.execute("Select top 10 * From [pro] where ComID = "&UID&" Order By Orders,PID")
while not rs.eof
if i <> 1 then%> | <%end if%><a href="Show.asp?PID=<%=Rs("PID")%>"><%=Rs("PName")%></a><%Rs.movenext
i = i + 1
wend%></marquee></td>
</tr>
#gd{
margin:10px;
padding:10px;
font-size:14px;
color:#666666;
}
margin:10px;
padding:10px;
font-size:14px;
color:#666666;
}
ASP语句和数据库查询逻辑……头疼
转载于:https://blog.51cto.com/iyuer2010/190524