同一页面内显示同一数据库不同查询集合!
<%
sql= "SELECT * FROM News where bigclassname= '学院新闻 ' ORDER BY id DESC "
rs.open sql,conn,1,1
do while not rs.eof
%>
<TR>
<TD align=left width= "13% " height=21>
<a class=link3 href= "news01.asp?id= <%=rs( "id ")%> " target= "_blank "> · <%=Left((rs( "title ")),20)%> </A>
<%
rs.movenext
loop
rs.close
%>
NEWS表里还有其他新闻,比如学生新闻,都要放到这个页面上,怎么做?
谢谢大家!帮帮忙!
------解决方案--------------------再照样写一段就OK了吧。
<%
sql= "SELECT * FROM News where bigclassname= '学院新闻 ' ORDER BY id DESC "
rs.open sql,conn,1,1
do while not rs.eof
%>
<TR> <TD align=left width= "13% " height=21>
<a class=link3 href= "news01.asp?id= <%=rs( "id ")%> " target= "_blank "> · <%=Left((rs( "title ")),20)%> </A> </TD> </TR>
<%
rs.movenext
loop
rs.close
set rs=nothing
set sql=nothing
%>
<%
sql= "SELECT * FROM News where bigclassname= '学生新闻 ' ORDER BY id DESC "
rs.open sql,conn,1,1
do while not rs.eof
%>
<TR> <TD align=left width= "13% " height=21>
<a class=link3 href= "news01.asp?id= <%=rs( "id ")%> " target= "_blank "> · <%=Left((rs( "title ")),20)%> </A> </TD> </TR>
<%
rs.movenext
loop
rs.close
set rs=nothing
set sql=nothing
%>