%
Response.Expires = 0
' º¯¼ö¼±¾ð
page = sqlCheck(Request("page"))
such_c = sqlCheck(Request("such_c"))
such_v = sqlCheck(Request("such_v"))
category = sqlCheck(Request("category"))
tablename = sqlCheck(Request("tablename"))
if Request("page")="" then
page = 1
end if
' µ¥ÀÌÅͺ£À̽º ÀÛ¾÷
if such_c <> "" and such_v <> "" then
sql="select * from dr_book where "&such_c&" like '%" &such_v&"%' and tablename = '"&tablename&"' order by title desc"
else
if category = "" then
sql="select * from dr_book where tablename = '"&tablename&"' order by title desc"
else
sql="select * from dr_book where tablename = '"&tablename&"' and category = '"&category&"' order by title desc"
end if
end if
set Rs=server.CreateObject ("ADODB.RecordSet")
Rs.PageSize = 8
Rs.Open sql,conn,1
%>
<%=happyjung_title%> > Á¤Çü¿Ü°ú ¼Ò°³ > »çÁøø
|
|
|
|
<%
totalrecord=rs.RecordCount
totalpage=rs.PageCount
rs.AbsolutePage = page
%>
|
|
Pages: <%=page%>/<%=totalpage%> |
¿Ã¶ó¿Â±Û: <%=totalrecord%> |
|
|
|
|
<%
i=1
do until rs.EOF or i>rs.PageSize
' ±ÛÀÚ À߶󳻱â
if len(rs("content")) > 12 then
content = left(rs("content"),12) & "..."
else
content = rs("content")
end If
' ±ÛÀÚ À߶󳻱â
if len(rs("title")) > 12 then
title = left(rs("title"),12) & "..."
else
title = rs("title")
end If
' À̹ÌÁö ÷ºÎ¿©ºÎ
If rs("up_file") = "" Then
file_name = "./no_img.gif"
Else
file_name = rs("up_file")
End if
' 4Ä Ãâ·ÂÈÄ ÁÙ¹Ù²Þ Ã³¸®
If i Mod 4 = 0 Then
%>
|
<%
Else
%>
|
<%
End if
rs.MoveNext
i=i+1
Loop
%>
|
|
|
|
|
<% If session("member") = "admin" Then %>
|
<% end if %>
<%
' ¸ÇóÀ½ ÆäÀÌÁö
if page > 1 then
Response.Write("")
else
Response.Write("")
end if
' ÀÌÀü 10 ÆäÀÌÁö
blockPage = int((page-1)/10)*10+1
if blockPage = 1 Then
'Response.Write("")
else
Response.Write ("")
end if
' ÇöÀç ÆäÀÌÁö ¸®½ºÆ®
i=1
Do until i > 10 or blockPage > totalpage
if blockPage = int(page) then
' ÇöÀç (¼±ÅÃ)ÆäÀÌÁö
Response.Write (" "& blockPage &" ")
else
' ¼±ÅõÇÁö ¾ÊÀº ÆäÀÌÁö ¸ñ·Ï
Response.Write (" "& blockPage &" ")
end if
blockPage = blockPage + 1
i = i +1
loop
' ´ÙÀ½ 10 ÆäÀÌÁö
if blockPage > totalpage Then
'Response.Write("")
else
Response.Write("")
end If
' ¸Ç¸¶Áö¸· ÆäÀÌÁö
if Cint(page) < Cint(totalpage) Then
Response.Write("")
else
Response.Write("")
end if
%>
|
|
|
|
|
|