Hi !!

I want to create multilevel category. The depth of subcategory is not limited. Thats means subcategory may be 2,3, and so on

My question is that what type of mysql database structure should i create ?

I have created following type structure

(1) Id - Integer
(2) Categoryname - Varchar
(3) parentid - Integer

Parentid will store id of parent category. If category is main category then its parentid will be ZERO.

I think this structure is correct. But i don't know that how should i display this all category.

Can you help me about what type of php loop programming i have to use?

Kindly just give me php loop programming which can display all category like this


Computer
    Hardware
        Model
        Sterlite company
            D-link company
    Networkcard
            D-link company
    Software
        php
    Asp.net
        Books
        Orelly
        Wrox
                   pdf format download
           Word Format download
Technology
   A-company
   B-company

I would like if anybody can help me regarding this.