<%
set rs=server.createobject("ADODB.Recordset")
sql="select * from P_info where p_other = 0 "
classType = request("classType")
smallclass = request("smallclass")
key = request("key")
if classType <> "" then
sql = sql & " and p_type = '"&classType&"'"
end if
if smallclass <> "" then
sql = sql & " and p_small_type = '"&smallclass&"'"
end if
if key <> "" then
sql = sql & " and p_name like '%"&key&"%'"
end if
sql = sql & " order by p_id desc"
rs.open sql,conn,1,1
if not isempty(request("page")) then
pagecount=cint(request("page"))
else
pagecount=1
end if
%>
<%
rs.close
set rs=nothing
%>
<%
'###############################新闻中心#############################
'根据后台新闻管理里面的新闻列别名称修改news_type的值,比如是业界动态等,如果后台修改了类别名字,请在这里做相应的修改
'news_language=0表示是中文类别的新闻,news_language=1表示英文类别的新闻
'top 20,表示显示新闻的条数,这里为20条
news_type = "太宇动态"
sql="select top 4 news.* from news,News_Class where news.news_class_id=news_class.news_id and news_language=0 and news_type = '"&news_type&"' order by news_date desc"
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,1,1
if not rs.eof then
do while not rs.eof
%>
|
|
|
|