<% sql="select top 5 * from tbl_pic where pictype=1 order by id desc"; rs=db.getResult(sql); while(rs.next()) { pictitle=rs.getString("pictitle"); if(pictitle.length()>8) {pictitle=pictitle.substring(0,8)+"...";} %> <% } rs.close(); %>

" alt="<%=rs.getString("picxilie")%>_<%=rs.getString("pictitle")%>" height="110" width="110" border="1" vspace="1" onclick="requestViewPhoto('<%=rs.getInt("id")%>')" hspace="1" class="smallPic" > <%=pictitle%>

<% sql="select top 5 * from tbl_pic where pictype=2 order by id desc"; rs=db.getResult(sql); while(rs.next()) { pictitle=rs.getString("pictitle"); if(pictitle.length()>8) {pictitle=pictitle.substring(0,8)+"...";} %> <% } rs.close(); %>

_<%=rs.getString("pictitle")%>" src="<%=rs.getString("pic_small_url")%>" height="110" width="110" border="1" vspace="1" hspace="1" onclick="requestViewPhoto('<%=rs.getInt("id")%>')" class="smallPic" > <%=pictitle%>

<% sql="select top 5 * from tbl_pic where pictype=4 order by id desc"; rs=db.getResult(sql); while(rs.next()) { pictitle=rs.getString("pictitle"); if(pictitle.length()>8) {pictitle=pictitle.substring(0,8)+"...";} %> <% } rs.close(); %>

_<%=rs.getString("pictitle")%>" src="<%=rs.getString("pic_small_url")%>" height="110" width="110" border="1" vspace="1" hspace="1" onclick="requestViewPhoto('<%=rs.getInt("id")%>')" class="smallPic" > <%=pictitle%>

<% sql="select top 5 * from tbl_pic where pictype=3 order by id desc"; rs=db.getResult(sql); while(rs.next()) { pictitle=rs.getString("pictitle"); if(pictitle.length()>8) {pictitle=pictitle.substring(0,8)+"...";} %> <% } rs.close(); %>

_<%=rs.getString("pictitle")%>" src="<%=rs.getString("pic_small_url")%>" height="110" width="110" border="1" vspace="1" hspace="1" onclick="requestViewPhoto('<%=rs.getInt("id")%>')" class="smallPic" > <%=pictitle%>