Display Catagories into Subcategories from database ?

[Fary4u]

Hi every one any body can help me in this regards ? i don't know how to do that
how do i convert following code into sub catagory ?
like . . .

Computer
    Mainboards
    Keyboards
    Mouse
Process
    Intel
    AMD
 

these catagories i've got in database

<%
    Dim Conn, rsCatalog
    Set Conn = Server.CreateObject("ADODB.Connection")
    Conn.Open ConString
    Set rsCatalog = Conn.Execute("SELECT * FROM catalogs")
        While Not rsCatalog.EOF
 
    Response.Write rsCatalog("catalogID")
        rsCatalog.MoveNext
        Wend
    rsCatalog.Close
    Set rsCatalog = Nothing
%>
 

but when i display it's just like not with subcatagories ?

Computer
Mainboards
Keyboards
Mouse
Process
Intel
AMD
 

but i want just main 2 catagories like Computer & Process then any body click on the Computer section then it's bring subcatagories ?

[markrawlingson]

There are many ways to do something but the easiest would be to define whether the item is a top level item or a sub category item at a database level. In other words, Put a bit value in your database table. If it's top level item define a value of false, if it's a sub-level item define a value of true.

Then check the value as you loop through each record..

If rs("bSubCategory") = False Then 'Boolean value of false, it is a top level item, simply write it on the page
   Response.Write rs("ID")
Else 'Boolean value of true, it's a sub-level item, put a blockquote around it to indent it to visually show it's a sub-level item.
   Response.Write "<blockquote>"
   Response.Write rs("ID")
   Response.Write "</blockquote>"
End If
 

Sincerely,
Mark

[Nicodemas]

Please read a recent post of mine to my personal blog about programming:

Hierarchical Data Using SQL

It explains a common database table structure and some sample queries in regards to hierarchical data.

[Fary4u]

Hi

i still not figer it out can you plz see my code & figer it out how the best way to find that

thaxxxxxxxxxxxxxxxxxxxxxx

[Fary4u]

i still not figer it out can you plz see my code & figer it out how the best way to find that