<!--#include file="conn.asp"-->
<%
set rs9=server.CreateObject("adodb.recordset")
sql="select top 4 * from news  where categoryid=135 order by newsid desc"
rs9.open sql,conn,3,3
 set rs10=server.CreateObject("adodb.recordset")
sql="select top 4 * from news where categoryid=136  order by newsid desc"
rs10.open sql,conn,3,3
 set rsp1=server.CreateObject("adodb.recordset")
sql="select  * from category where categoryid=146  order by categoryid desc"
rsp1.open sql,conn,3,3
 set rsp2=server.CreateObject("adodb.recordset")
sql="select  * from category where categoryid=147  order by categoryid desc"
rsp2.open sql,conn,3,3
 set rsp3=server.CreateObject("adodb.recordset")
sql="select  * from category where categoryid=148  order by categoryid desc"
rsp3.open sql,conn,3,3
 set rsp4=server.CreateObject("adodb.recordset")
sql="select  * from category where categoryid=149  order by categoryid desc"
rsp4.open sql,conn,3,3
%>
同上,怎么写才更好,,

这样写发到空间服务器会很慢,,怎么写才更好,,谢了,

查询取值呀,

<table width="100%"  border="0" cellspacing="0" cellpadding="0">
                     <tr><td height="16"></td></tr>
      <% do while not rs9.eof %>
       <tr>
                        <td width="9"><img src="img/dian.jpg" width="9" height="13"></td>
                        <td width="186"><a href="newsdetail.asp?id=<%=rs9("newsid") %>"><%=rs9("newsname")%></a></td>
                        <td width="26"><%if datediff("d",rs9("adddate"),date())<5 then%>
<img src="img/index_new.gif" width="28" height="11">
<%end if%></td>
                      </tr>
       <tr><td height="10"></td></tr>
        <% rs9.movenext
      loop %>
      <% rs9.close
      set rs9=nothing%>
                    </table>

无非就是在一个地方输出一个值,(一个图片,或者一个文字从数据库里读的)怎么改呀,

建立一个,怎么对多个表进行操作?

我好像明白了,,

另一个地主也可以这样写吗,会不会冲突..

可是前提,我得知道怎么让他快,,,

我知道怎么写了,,谢谢楼上的,我可以建议让他们加两个CPU,,