Question

用ASP语句写一级分类名称带链接

ACCESS 数据库,其中一表 表名:classname,表中项classid classname,想写一个显示所有分类名称的语句.
写个全套的,带首尾的,单独的语句,我也会写,就是组合在一起老错误.

Answer 1

<table><tr>
<td>类别id</td><td>类别名称</td></tr>
<%dim i
i=0
set rs=server.CreateObject("adodb.recordset")
rs.open "select top 6 classid,classname from classname order by classid desc",conn,1,1
if rs.eof and rs.bof then
response.write "没有记录"
else
do while not rs.eof
i=i+1%>
<tr>
<td><%
response.write rs("classid")
%> </td>
<td><%
response.write rs("classname")
%></td>
</tr>
<%rs.movenext
loop
rs.close
set rs=nothing%>
</table>

Answer 2

Set Rs=Conn.Execute("Select * From [classname] Order by id asc")
do while Not (Rs.eof or Rs.Bof)
'链接部分
Response.Write "<a href=search.asp?id="&rs("classid")&" title="&rs("classname")&">"&rs("classname")&"</a><br>"
rs.movenext
loop
set Rs=Nothing

Answer 3

语句：
select classid,classname from classname order by classid

链接：
<a href="a.asp?id=<%=rs(0)%>"><%=rs(1)%></a>
或
<a href="a.asp?id=<%=rs("classid")%>"><%=rs(classname)%></a>