主题:从数据库读两张表,显示有误,请问这段如何修改使显示正常,先谢谢了
现在这段代码显示有误,要实现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>
<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>