Code for displaying categories and subcategories using PHP

Hi All
Can anybody share code for displaying categories and subcategories with me

Example Main Category->Subcategory->Child category->Child Subcategory-> upto any level
Thanks

 

while(loop into Main categ)
{

    while(loop into subcateg)
    {
        while(loop into subofsubcateg)
        {
        ..... up to any level
         }

     }
}

PHP:

but you better not go far in depth and you should not get too many categories as well other wise that kind of query will take a long time and consume a lot resources...
You could also go with recursive queries but Php is not a recursive language!

 

Also it depends how you organize your data; are you using one table or several tables?

 

Iam using only one table
i need results as follows
first there are root categories like

India
USA
Canada

If i click on india next the result is
india
>> New Delhi
>>Bombay
>>Madras
USA
CANADA

Next if i click on
>>New Delhi

The result is
India
>>New Delhi
>>>>Colony 1
>>>>Colony 2
>>Bombay
>>Madras
USA
CANADA

It works on onclick event
i have a table called Categories
CID CNAME PID
1 INDIA 0
2 USA 0
3 CANADA 0
4 New Delhi 1
5 Bombay 1

CID is category ID ,PID is parent ID,Cname is name of Category

Kindly Reply

 

So that should be like this to retrieve all:

$query=mysql_query("SELECT name,id FROM yourtable");
while($l=mysql_fetch_assoc($query))
{
  $query1=mysql_query("SELECT name,id FROM yourtable WHERE pid=".$l['id']);
  while($l1=mysql_fetch_assoc($query1))
  {
....
  }


}

PHP:

Then you orgnize your data with your javascript or do some Ajax to display onclick event.

 

Take a look at this: http://www.sitepoint.com/article/hierarchical-data-database