|
| 站
内 搜 索 |
|
<%call search()%> |
|
| 推
荐 新 闻 |
|
<% sql = "SELECT * FROM jjh_department ORDER BY department_id asc"
Set rs = Server.CreateObject("ADODB.Recordset")
rs.OPEN sql,Conn,1,1
i=1
if rs.bof and rs.eof then
rs.close
response.write "没有信息"
else
do while not rs.eof
%>
"><%= rs("department_name") %> |
<% i=i+1
rs.movenext %>
<% if not rs.eof then %>
<% End If %> "><%= rs("department_name") %> |
<% i=i+1
rs.movenext %>
<%
loop
rs.close
end if
%>
|
|
| 点
击 排 名 |
|
| <% sql = "SELECT top 8 * FROM jjh_activ ORDER BY activ_hits desc"
Set rs = Server.CreateObject("ADODB.Recordset")
rs.OPEN sql,Conn,1,1
if rs.bof and rs.eof then
rs.close
response.write "没有信息"
else
do while not rs.eof
%>
<%
rs.movenext
loop
rs.close
end if%>
|
|
| |
|
|
|
全 部 结 果 |
|
<%
set rs=server.createobject("adodb.recordset")
sql="select * from "&findword&" "
sql=sql&" order by "&jie&"_id desc"
rs.open sql,conn,1,1
if rs.bof and rs.eof then
rs.close
response.write "没有查询到你要的信息!"
else
do while not rs.eof
%>
<%
rs.movenext
loop
rs.close
end if%> |
|
|
| |
|