% hor=2 vert=4 perp=hor*vert '***************************************************************************** Set adoCon = Server.CreateObject("ADODB.Connection") strCon = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("db/foto.mdb") '--------------------------------------------------------------------------------------------------------------------------------------------- pagea=CInt(Request("pagea")) album1=CInt(Request("album_num")) if pagea<1 then page1=1 if album1<1 then album1=1 recordcount=0 adoCon.Open strCon Set rs = Server.CreateObject("ADODB.Recordset") strSQL = "SELECT * FROM foto_"&album1&" ORDER BY ID DESC;" rs.Open strSQL, adoCon rs.movefirst while not rs.eof recordcount=recordcount+1 rs.movenext wend rs.Close strSQL = "SELECT * FROM foto_"&album1&" Where (ID>" &(recordcount/perp - pagea)*perp&") and (ID<=" &(recordcount/perp - pagea+1)*perp& ") ORDER BY ID DESC;" rs.Open strSQL, adoCon rs.Movefirst %>
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||