| |
<%
for pi=1 to 3
sqltext="select * from product where nomflag='1' and state='1' order by updatetime desc"
rs.Open sqltext,cn,1,1
pagesize=3
rs.PageSize=pagesize
if rs.PageCount>0 then rs.AbsolutePage=pI
pagecount=rs.PageCount
i=1
%>
<%do while not rs.EOF and i<=pagesize %>
<%if rs("picflag")="1" then%>
 " alt="a" width="70" height="70" border="0" align=center />
<% else %>
<%end if %>
|
<%= rs("title") %> |
| Art no.
<%if trim(rs("artno"))<>"" then%>
<%=rs("artno")%>
<%end if%>
|
|
&keyno=<%= rs("prono") %>">Details |
|
|
<%i=i+1
rs.movenext
loop
rs.close
%>
|
<%next%>
|
|
tony@darjou.com 