Clike here: All Faq Question
<%sort_1="index"
speaktype=""
speaktype=request("speaktype")
%>
<%set rs=server.createobject("adodb.recordset")
sql="select * from speak where 1=1 "
if speaktype<>"" then sql=sql&" and speaktype='"&speaktype&"' "
sql=sql&" order by id desc"
rs.open sql,conn,3,1
speaktype=request("speaktype")
rs.PageSize =10
page=Request("page")
if not isnumeric(page) then page=1
page=cint(page)
if page="" then
page=1
end if
if page<1 then
page=1
end if
if page>rs.PageCount then
page=rs.PageCount
end if
%>
<%if rs.RecordCount >0 then
count=0
rs.AbsolutePage=cint(page)
%>
<%while (not rs.eof) and count- " target="_blank"> <%=rs("title")%>
- <%=year(rs("dateinput"))&"-"&month(rs("dateinput"))&"-"&day(rs("dateinput"))%>