我从数据库里调三条最新消息出来,代码如下,.结果输出是竖着排列,.我希望得到横向排列的结果... 请高手指点,要求把代码写全,呵呵,因为我没学过编程...谢谢先.<%sql="select top 3 * from NEWS where firstImageName<>'' and ok=true order by ID DESC"set rs=conn.execute(sql)if rs.eof and rs.bof thenresponse.write "<tr><br><br><br><br><td align=center colspan=2 bgcolor=#E8E8F4>精彩活动稍后推出</td></tr>"elseDo While Not RS.EOF%><table id='time' width='175' border='0' cellpadding='0' cellspacing='0'><tr height='16'><td height='16' width="226"><a href="onews.asp?id=<%=rs("id")%>" target="_blank" ><p align="left"><font color='#ff3300'><b><%=left(rs("title"),12)%></b></font></p></a></td></tr><tr><td width="226"><p align="center"><a href="onews.asp?id=<%=rs("id")%>" target="_blank" ><img src="uppic/<%=trim(rs("firstImageName"))%>" width="224" height="253" border="0"></a></p></td></tr></table><%RS.MoveNextLoopend ifrs.closeset conn=nothing%>
參考答案:太简单啦,来试试
我,先声名哦,你们面的表格并没有结束,你插入时最好是照着原来的地方插入,后面应该有结束表格的,这样就不会乱了,我只是加了个表格进去,嘿嘿
<%
sql="select top 3 * from NEWS where firstImageName<>'' and ok=true order by ID DESC"
set rs=conn.execute(sql)
if rs.eof and rs.bof then
response.write "<tr><br><br><br><br><td align=center colspan=2 bgcolor=#E8E8F4>精彩活动稍后推出</td></tr>"
else
%>
<table id='time1' width='100%' border='0' cellpadding='0' cellspacing='0'>
<tr>
<%
Do While Not RS.EOF
%> <td valign="top">
<table id='time' width='175' border='0' cellpadding='0' cellspacing='0'>
<tr height='16'>
<td height='16' width="226"><a href="onews.asp?id=<%=rs("id")%>" target="_blank" ><p align="left"><font color='#ff3300'><b><%=left(rs("title"),12)%></b></font></p></a></td>
</tr>
<tr>
<td width="226">
<p align="center"><a href="onews.asp?id=<%=rs("id")%>" target="_blank" ><img src="uppic/<%=trim(rs("firstImageName"))%>" width="224" height="253" border="0"></a></p>
</td>
</tr>
</table> </td>
<%
RS.MoveNext
Loop
end if
rs.close
set conn=nothing
%></tr></table>