＋设为首页 ＋添加到收藏夹
如题！
<select name="sort" size="1" id=sort>
<option selected>－－按标题查找－－</option>
<% sql="select 一级目录 from 目录列表 where 1=1 group by 一级目录"
rs.open sql,cn,1,1
if rs.eof then
response.write "</b>rs eof error</b>"
response.write sql
response.end
end if
do while not rs.eof
response.write " <option >"&rs(0)&"</option>"
rs.movenext
loop
rs.close
%>
</select>
是不是这样
select distinct 字段1 from Table order by 字段1
