P_id, P_name ,P_parent_id
1 , 產品1 , 0
2 , 產品2 , 0
3 , 產品3 , 0
4 , 產品11 , 1
5 , 產品21 , 2
然後用壹個循環取出產品類
sql=“select*from pro where P_parent_id=0”'P_parent_id等於0為大類
if rs.eof then
do while not rs.eof
response.write(rs("P_name"))
sql_small=“select*from pro where P_parent_id=”&rs("P_id")'取出P_id大類對應的小類
if rs_small.eof then
do while not rs_small.eof
loop
end if
loop
end if