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 . . .

Expand|Select|Wrap|Line Numbers

 
Computer

    Mainboards

    Keyboards

    Mouse

Process

    Intel

    AMD

these catagories i've got in database

Expand|Select|Wrap|Line Numbers

 
<%

    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 ?

Expand|Select|Wrap|Line Numbers

 
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..

Expand|Select|Wrap|Line Numbers

 
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

Display Catagories into Subcategories from database ?

re: Display Catagories into Subcategories from database ?

re: Display Catagories into Subcategories from database ?

re: Display Catagories into Subcategories from database ?

re: Display Catagories into Subcategories from database ?

Similar ASP / Active Server Pages bytes

/bytes/development

/bytes/it

/bytes/about