[求助]添加分类问题
我在写一个添加分类的小程序,现在有六个大类已经定下来了,在根据这六个大类添加二级和三级分类~!我应该建几个数据库表,程序怎么写.谢谢帮忙.小弟很着急.
2007-07-11 17:44
建两个表:
参考程序如下:
<%dim rs1
set rs1=server.CreateObject("adodb.recordset")
rs1.open "select * from product where id="&id,conn,1,1
rs.open "select * from daclass order by da_id",conn,1,1
%>
<select name="da_id" size="1" id="da_id" onChange="javascript:location='?da_id='+document.all.da_id.value+'';">
<%do while not rs.eof%>
<option value="<%=rs("da_id")%>"<%if request("da_id")=rs("da_id") then%>selected<%end if%>><%=trim(rs("daclass"))%></option>
<%
rs.movenext
loop
rs.close
%>
</select>
<select name="xiao_id">
<%rs.open "select * from xiaoclass where xiao_id="&request("xiao_id") ,conn,1,1
do while not rs.eof%>
<option value="<%=rs("xiao_id")%>"><%=rs("xiaoclass")%></option>
<% rs.movenext
loop
rs.close
set rs = nothing
%>
</select>
2007-07-11 18:17
2007-07-11 18:26