<% 'From menu sql = "select * from bands where grp_id = "& grp_id &" ORDER BY band_id DESC" set rs = conn.execute(sql) overall = rs.recordcount if not rs.eof then if request("no") ="" then pageno =1 else pageno=request("no") end if total = rs.recordcount pagesize= 20 totalpage = total\pagesize if (total mod pagesize) <> "0" then totalpage= totalpage+1 else totalpage = 0 end if rs.Move pagesize*(pageno-1) a=1 if trim(pageno) <> trim(totalpage) then endrecord = pagesize else endrecord=(total mod pagesize) end if For a=1 to endrecord %>

<%=imgsrcfull(rs("band_picture"), rs("band_picturex"), rs("band_picturey"), 120, 1, 1, 1)%> "><%=rs("band_name")%> <%=rs("band_describe")%> "> view detail

<% rs.movenext next set rs = nothing end if %>

Found : <%=overall%> item(s)

<%for ppp = 1 to totalpage%> <%=ppp%>  <%next%>