回 帖 发 新 帖 刷新版面

主题:从数据库读两张表,显示有误,请问这段如何修改使显示正常,先谢谢了

现在这段代码显示有误,要实现http://www.0574.tv/中“商家点评”一样的显示该如何改?

<table width="97%"  border="0" align="center" cellpadding="0" cellspacing="0">
                                <%
              m_SQL = "SELECT top 4 * FROM CityCard_LeagueReview ORDER BY F_ID DESC"
              Set rs = conn0.Execute(m_SQL)
              Do While Not rs.Eof
              F_Name=rs("F_Name")
              F_Content=rs("F_Content")
              %>
                                <%
m_SQL = "SELECT * FROM CityCard_League WHERE ischecked=1 ORDER BY companyid DESC"
Set rs1 = conn0.Execute(m_SQL)
Do While Not rs1.Eof
companyid=rs1("companyid")
companyname=rs1("name")
logo=rs1("logo")
%>
                                <tr> 
                                  <td width="70" rowspan="2" align="center"> 
                                    <%if rs1("logo")<>"" then %>
                                    <img src="CardManage/UploadLogoImages/<%=logo%>" width="50" height="40"> 
                                    <%else%>
                                    <img src="images/nobizpic.gif" width="50" height="40"> 
                                    <%end if%>
                                  </td>
                                  <td>·<%=F_Name%> 评论 <a href="card/Show.asp?id=<%=companyid%>"><%=companyname%></a></td>
                                </tr>
                                <tr> 
                                  <td><%=F_Content%></td>
                                </tr>
                                
                                <tr> 
                                  <td height="1" background="images/line.gif"></td>
                                  <td background="images/line.gif"></td>
                                </tr>
<%
rs1.MoveNext
Loop
rs1.close
%>
<%
rs.MoveNext
Loop
rs.close
%>

                              </table>

回复列表 (共3个回复)

沙发

各位,请问该如何修改,

板凳

什么有误?是代码显示有错误,还是显示的内容不对?如果是错误报了什么错?
另外我没看懂的是为什么循环里面又套了一个循环?这两个循环似乎没有关系,这样岂不是内层的循环会重复好几次嘛!

3 楼

上一问题已解决,现在再请教一问题,以下两种方式哪个的处理速度更快些?谢谢

1
<%
m_SQL1 = "SELECT * FROM * BY id DESC"
Set rs1 = conn0.Execute(m_SQL1)
if not rs1.eof then

  if rs1("logo")<>"" then
   logo1=rs1("logo")
  else
   logo1="nobizpic.gif"
  end if
end if
%>
下面直接引用<img src="*/<%=logo1%>

2
<%
m_SQL1 = "SELECT * FROM * BY id DESC"
Set rs1 = conn0.Execute(m_SQL1)
if not rs1.eof then
logo1=rs1("logo")
end if
%>
引用时:

<%if logo1<>"" then %>
<a href="*.asp?id=<%=id%>"><img src="*/<%=logo1%>"></a> 
<%else%>
<img src="nobizpic.gif">                                    
<%end if%>


请指教,谢谢

我来回复

您尚未登录,请登录后再回复。点此登录或注册