|
|
| 您查询的内容为：<%
title1=request("class")
title2=request("big")
title2=request("bigclass")
if title2="" then
%>
<%=title1%>
<%else%>
<%=title2%> <%=title1%>
<%end if%>
<%
page=clng(request("page"))
key=request("key")
key2=request("key2")
area=request("area")
big=request("big")
smallclass=request("class")
bigclass=request("bigclass")
set rslook=server.createobject("adodb.recordset")
if key2="cp" then
if smallclass<>"" and big <>"" then
sql77="select * from info where smallclass='"&smallclass&"'and bigclass='"&big&"' order by vip desc, tuijian desc, id asc"
aa=1
end if
if area<>"" then
sql77="select * from info where gscontent like '%"& key &"%' and whereee='"&area&"' order by vip desc, tuijian desc, id asc"
bb=1
end if
if area="日照" then
sql77="select * from info where gscontent like '%"& key &"%' order by vip desc, tuijian desc,id asc"
bb=1
end if
if bigclass<>"" and smallclass="" then
sql77="select * from info where bigclass='"&bigclass&"' order by vip desc, tuijian desc, id asc "
cc=1
end if
else
if key2="tel" then
if smallclass<>"" and big <>"" then
sql77="select * from info where smallclass='"&smallclass&"'and bigclass='"&big&"' order by vip desc, tuijian desc, id asc"
aa=1
end if
if area<>"" then
sql77="select * from info where phone like '%"& key &"%' and whereee='"&area&"' order by vip desc, tuijian desc, id asc"
bb=1
end if
if area="日照" then
sql77="select * from info where phone like '%"& key &"%' order by vip desc, tuijian desc,id asc"
bb=1
end if
if bigclass<>"" and smallclass="" then
sql77="select * from info where bigclass='"&bigclass&"' order by vip desc, tuijian desc, id asc "
cc=1
end if
else
if key2="dz" then
if smallclass<>"" and big <>"" then
sql77="select * from info where smallclass='"&smallclass&"'and bigclass='"&big&"' order by vip desc, tuijian desc, id asc"
aa=1
end if
if area<>"" then
sql77="select * from info where address like '%"& key &"%' and whereee='"&area&"' order by vip desc, tuijian desc, id asc"
bb=1
end if
if area="日照" then
sql77="select * from info where address like '%"& key &"%' order by vip desc, tuijian desc,id asc"
bb=1
end if
if bigclass<>"" and smallclass="" then
sql77="select * from info where bigclass='"&bigclass&"' order by vip desc, tuijian desc, id asc "
cc=1
end if
else
if smallclass<>"" and big <>"" then
sql77="select * from info where smallclass='"&smallclass&"'and bigclass='"&big&"' order by vip desc, tuijian desc,id asc"
aa=1
end if
if area<>"" then
sql77="select * from info where company like '%"& key &"%' and whereee='"&area&"' order by vip desc, tuijian desc,id asc"
bb=1
end if
if area="日照" then
sql77="select * from info where company like '%"& key &"%' order by vip desc, tuijian desc,id asc"
bb=1
end if
if bigclass<>"" and smallclass="" then
sql77="select * from info where bigclass='"&bigclass&"' order by vip desc, tuijian desc,id asc"
cc=1
end if
end if
end if
end if
rslook.open sql77,conn,1,3
if rslook.eof or rslook.bof then
response.write""
else
%> |
<%
dim rrrr
rrrr=0
set rsrs=server.createobject("adodb.recordset")
sql="select * from smallclass where bigclass='"& bigclass &"'order by sorder asc"
rsrs.open sql,conn,1,3
%>
<%
do while not rsrs.eof
%>
<%
if (rrrr mod 5) <> 0 then
%>
|
<%
else
%>
|
|
<%
end if
rsrs.movenext
rrrr=rrrr+1
if rsrs.eof then
for j=1 to 5 - rrrr mod 5
response.write(" | ")
next
end if
loop
%>
|
<%
rslook.PageSize=14
if page=0 then page=1
pages=rslook.pagecount
if page > pages then page=pages
rslook.AbsolutePage=page
for j=1 to rslook.PageSize
%>
<%
rslook.movenext
if rslook.eof then exit for
next
end if
%>
<%if Page<2 then
response.write "首页 上一页 "
else
response.write "首页 "
response.write "上一页 "
end if
if rslook.pagecount-page<1 then
response.write "下一页 尾页"
else
response.write ""
response.write "下一页 尾页"
end if
response.write " 页次："&Page&"/"&rslook.pagecount&"页 "
response.write " 共"&rslook.recordcount&"条记录 "&rslook.pagesize&"条记录/页"
%>
|
<%else%><%=rslook("company")%>
<%
end if
%>