|
|
<%
'//列表三个最热门的产品目录
sql = "select top 3 * from type1 where type1_grade=1 order by type1_sort"
rs.open sql,cc.conn,1,1
i = 0
do while not rs.eof
response.Write "| "&rs("type1_name_en")&" | &") | | "&left(rs("type1_memo_en"),150)&" | | READ MORE |
"
rs.movenext
i = i + 1
if i= 3 then exit do
loop
rs.close()
%>
| Hot selling |
More>> |
<%
'//列表4个热门的产品
sql = "select top 4 product_id,product_name_en,product_shortdesp_en,product_simg,product_title_en from product where product_hotting=true and product_enable=true order by product_sort"
rs.open sql,cc.conn,1,1
if not(rs.bof and rs.eof)then
i = 1
do while not rs.eof
response.Write " "
rs.movenext
i = i + 1
if i = 5 then exit do
loop
else
response.Write "find no record"
end if
rs.close()
%>
|
|