| |
| 二手信息分类导航 |
|
<%=Application("flea_1")%>
| |
| 客户必读须知 |
|
免责声明:
本站所有信息及内容,均为企业或个人会员发布,请注意识别验证信息的虚假。据此交易风险自负!<%=my_name%>不提供任何保证,并不承担任何法律责任。 |
二手功能道具介绍:
二手市场设置了三个道具,即信息更新道具(更新已发信息的发布时间),标题标红道具(将信息主题颜色标成红色48小时),信息置顶道具(能使发布信息置顶,有效时间为24小时;使用个数越多,位置越高。 |
关于虚拟<%=my_je%>说明:
用户虚拟<%=my_je%>是用户注册奖励、登录网站的次数奖励、发信息奖励、回答问题等的虚拟<%=my_je%>的总金额构成。 >>查看更多介绍 |
|
|
<%set s = Server.CreateObject("shuziren_com.yz")
Set rs=Server.CreateObject("ADODB.Recordset")
if request("lbid")<>"" and isnumeric(request("lbid")) and request("key")<>"" then
sql="select top 10000 id,lx,bt,sj2,css,ding,js,js2,tp from gq where zt=1 and lbid="&s.shuzi("lbid")&" and bt like '%"&s.txt("key")&"%' order by id desc"
elseif request("key")<>"" then
sql="select top 10000 id,lx,bt,sj2,css,ding,js,js2,tp from gq where zt=1 and bt like '%"&s.txt("key")&"%' order by id desc"
elseif request("lbid")<>"" and isnumeric(request("lbid")) then
sql="select top 10000 id,lx,bt,sj2,css,ding,js,js2,tp from gq where zt=1 and lbid="&s.shuzi("lbid")&" order by ding desc,sj2 desc"
elseif request("abc")<>"" and isnumeric(request("abc")) then
Select case request("abc")
case "1"
sql="select top 10000 id,lx,bt,sj2,css,ding,js,js2,tp from gq where zt=1 order by ding desc,js desc,sj2 desc"
case "2"
sql="select top 10000 id,lx,bt,sj2,css,ding,js,js2,tp from gq where zt=1 and lx=0 order by ding desc,sj2 desc"
case "3"
sql="select top 10000 id,lx,bt,sj2,css,ding,js,js2,tp from gq where zt=1 and lx<>0 order by ding desc,sj2 desc"
case else
sql="select top 10000 id,lx,bt,sj2,css,ding,js,js2,tp from gq where zt=1 order by ding desc,sj2 desc"
End Select
else
sql="select id,lx,bt,sj2,css,ding,js,js2,tp from gq where zt=1 order by ding desc,sj2 desc"
end if
rs.open sql,conn,1,1
If rs.eof Then
Response.Write("| 对不起,目前暂无符合的信息! | ")
Else
page1("30")
i=1
do while not rs.eof and i<=rs.pagesize%>
|
<%response.write ""
If rs("lx")=0 Then
response.write"卖"
Else
response.write"买"
End If%>
|
<%if rs("tp")<>"" then tp=" " else tp=""
if rs("css")<>0 then
response.write tp&""&left((rs("bt")),25)&""
else
response.write tp&""&left((rs("bt")),25)&""
end if
if rs("ding")<>0 then Response.Write(" "&rs("ding")&"")%>
|
<%=rs("js")%>/<%=rs("js2")%> |
<%=formatdatetime(rs("sj2"),2)%> |
<%i=i+1
rs.MoveNext
loop
End If
if i<30 then
for h=0 to 30-i
response.write" | | | | "
next
end if%>
| |
|
<%
page2("abc="&request("abc")&"&lbid="&request("lbid")&"&key="&request("key")&"&")
rs.close
set rs=nothing
conn.close
set conn=nothing
set s=nothing%>
|
|
|