 |
|
|
 |
 |
 |
|
|
按作品内容关键字查找,如:鸽、龟、梅花等 |
|
|
|
| 最后更新日期:2007.7.16 |
|
<%
fenlei=Trim(Request("fenlei"))
xingshi=Trim(Request("xingshi"))
keyword=Trim(Request("keyword"))
%>
| 目前显示的作品范围是:
<%If fenlei="" and xingshi="" and keyword="" then
Response.Write("全部")
end if%>
<%=(fenlei)%><%=(xingshi)%><%=(keyword)%> |
<%
sql="select * from guohua where show=1 order by id desc"
if fenlei<>"" then
sql="select * from guohua where fenlei='"& fenlei &"' and show=1 order by heng*shu desc, id desc"
end if
if xingshi<>"" then
select case xingshi
case "中堂"
sql="select * from guohua where shu>heng and shu<=2*heng and show=1 order by heng*shu desc, id desc"
case "斗方"
sql="select * from guohua where shu=heng and show=1 order by heng*shu desc, id desc"
case "横幅"
sql="select * from guohua where shu"" then
sql="select * from guohua where mingcheng like '%"& keyword &"%' or neirong like '%"& keyword &"%' order by heng*shu desc, id desc"
end if
set tiezi=server.CreateObject("adodb.recordset")
tiezi.open sql,lj,1,2
if tiezi.bof and tiezi.eof then
Response.Write("尚未有您查找的作品发布,谢谢关注!
| ")
else
if request("ye")="" then
ye=1
else
ye=cint(request("ye"))
end if
tiezi.pagesize=4
tiezi.absolutepage=ye
zong=tiezi.pagecount
tou=4
do while not tiezi.eof and tou>0
tou=tou-1
%>
| |
|
(点击放大) |
作品编号:GH0<%=(tiezi("ID"))%> 检索分类:<%=(tiezi("fenlei"))%>
作品名称:《<%=(tiezi("mingcheng"))%>》
作品尺寸:约 <%=(tiezi("heng"))%>x<%=(tiezi("shu"))%>尺
说 明:<%=(tiezi("shuoming"))%> |
| |
|
<%tiezi.movenext
loop
end if%>
|
<%
if ye=1 then
response.Write("首页 上一页 ")
end if
if ye<>1 then
response.Write("首页 ")
response.Write("上一页 ")
end if
if ye<>zong then
response.Write("下一页 ")
response.Write("末页")
end if
if ye=zong then
response.Write("下一页 末页")
end if
response.Write(" 共"&zong&"页")
response.Write(" 第"&ye&"页")
%>
|
|
 |
 |
|
|
|
 |
版权所有:野柳书画网 制作维护:北京金长安文化艺术发展有限公司
意见反馈:yeliu@yeliu.net 网站管理:webmaster@yeliu.net
地址:北京市东长安街甲105号A栋10层 |
|
|