rs.Open sql,conn,1
i=1
do while not rs.eof
%> <td align="center" height="98">
<a href="show.asp?id=<%=rs("id")%>">
<img src="<%=rs("pic")%>" width="150" height="98" alt="<%=rs("name")%>" /></a>
</td>
<%
if i mod 3 = 0 then
Response.Write("</tr><tr>")
end if
i=i+1
if i>p then exit do
rs.movenext
Loop
rs.close
set rs=nothing
%>
