一个排序的问题！==（急）{在线等代}

[cnpr]

数据库中有N条记录。

我想让它这样排序（如下：）


a b c
d e f
g h ....

这样的排序。请大家帮帮我。谢谢！！！

[Jaron]

SELECT * from 表名 ORDER BY 字段名 [DESC]

[xiaobird1]

SELECT * from 表名 ORDER BY 字段名
...
i = 1
while not rs.EOF
Response.write rs("字段")
if i = 3 then
Response.write "<br>"
end if
i = i + 1
wend

[eduxh]

i=0
while not rs.eof
if i=0 then
response.write "<tr>"
end if
response.write "<td>.......</td>"
i=i+1
if i=3 then
response.write "</tr>"
i=0
end if
rs.movenext
loop
if i!=0 then
for i=i to 3
response.write "<td></td>"
next
response.write "</tr>"
end if

[bubuy]

dim i
i=0
whlie not rs.eof
i=i+1
response.write rs("字段")
if i mod 3 =0 then
response.write "br"
end if
rs.movenext

wend

[eduxh]

把loop改成wend

[eduxh]

把loop改成wend

[bubuy]

上面response.write "br"写错了，下面这样
dim i
i=0
whlie not rs.eof
i=i+1
response.write rs("字段")
if i mod 3 =0 then
response.write "<br>"
end if
rs.movenext

wend

[cnpr]

thanks......

all friends!!