我要在一行显示4个文章标题，数据库查询语句怎么写啊？我现在出来的是：在一列显示4个标题！现在的语法是：
 
                   <%
set rs=server.CreateObject("adodb.Recordset")
sql="select  name from kehu "
rs.open sql,conn,1,1
if rs.eof then%>
                  
    <tr>
                              <td height="8" align="center"><strong>暂无客户信息!</strong></td>
                            </tr>
                            <%else
do while not rs.eof
%>
                            <tr>
                              <td height="22"><img height="5" src="image/icon_dot01.gif" width="5">
                                <%if len(rs("name")) > 14 then Response.write left(rs("nema"),14)&"..." else Response.write rs("name") end if%>
                              </td>
                            </tr>
                            <%     
rs.movenext
loop
rs.close
set rs=nothing
end if%>              

请问应该怎么修改啊？让他一行显示4个文章标题！

循环放在<tr>里面.

试了，没用啊！能详细说明一下吗？谢谢！或者是让他生成的格式和表格一样，一行4条！

sql="select top 4 name from kehu "

<%
set rs=server.CreateObject("adodb.Recordset")
sql="select  name from kehu "
rs.open sql,conn,1,1
if rs.eof then%>
                  
    <tr>
                              <td height="8" align="center"><strong>暂无客户信息!</strong></td>
                            </tr>
                            <%else %>
                            <tr>
                              <td height="22"><img height="5" src="image/icon_dot01.gif" width="5">
                                <%
do while not rs.eof
if len(rs("name")) > 14 then Response.write left(rs("nema"),14)&"..." else Response.write rs("name") end if
rs.movenext
loop
%>
                              </td>
                            </tr>
                            <%    rs.close
set rs=nothing
end if%>         

left(rs("nema"),14)写错了不会提示错误么？改成left(rs("name"),14)

你要横着排,你就要知道html语言了.


你现在的循环是在<tr></tr>里,当然是列排.  你在循环前加个</td></tr><tr><td>

就行了

<table width="94%" border="0" align="right" cellpadding="0" cellspacing="0">
                <tr>
                <%
set rs=server.CreateObject("adodb.Recordset")
sql="select  * from kh "
rs.open sql,conn,1,1
if rs.eof then%>
                  
    <tr>
                              <td height="8" align="center"><strong>暂无客户信息!</strong></td>
                            </tr>
                            <%else
do while not rs.eof
%>
                            <tr>
                              <td height="22"><img height="5" src="image/icon_dot01.gif" width="5">
                                <%if len(rs("name")) > 100 then Response.write left(rs("nema"),100)&"..." else Response.write rs("name") end if%>
                              </td>
                            <td>
                            <%     
rs.movenext
loop
rs.close
set rs=nothing
end if%>
</td>                  
</tr>                  
               
              </table>

这是我现在的写法！
现在显示的是
A
A
A
A
A
A
A
A
这样的，我想让他显示成
A A
A A
A A
A A
就是一个TABLE里，现在显示的是一列，我想让他变成，达到20条后，自动变成2列！高手帮忙啊，救命啊！

<table width="94%" border="0" align="right" cellpadding="0" cellspacing="0">
<tr><td>
<%
set rs=server.CreateObject("adodb.Recordset")
sql="select  * from kh "
rs.open sql,conn,1,1
if rs.eof and rs.bof then
else
i=0
do while not rs.eof '现在这里开始循环
if a mod 20 =0 then '如果是20的倍数则插入分格符
response.write "</td><td>"
end if
%>
<table><tr><td><img height="5" src="image/icon_dot01.gif" width="5">
                                <%if len(rs("name")) > 100 then Response.write left(rs("nema"),100)&"..." else Response.write rs("name") end if%>
</td></tr></table>
 <%     
 i=i+1
rs.movenext
loop
rs.close
set rs=nothing
end if%>
</td></tr></table>

do while not rs.eof '现在这里开始循环
if a mod 20 =0 then '如果是20的倍数则插入分格符
response.write "</td><td>"
end if

中的 a mod 20 写错  是 if i mod 20 = 0 then