A lot of people can easily do this, but I seem to be having some trouble.
With the same table, i want to be able to create categories with unlimited sub categories.
Can somebody point me to the right direction to learn about this?
Or can I have a simple function that does this to build/learn off of?
If I haven't explained this well enough, I can try better if there is confusion caused.
Thanks in advance.

Welcome to the community Matt It's always a pleasure to see a new face! I actually described a solution to this only the other day over here. If that solution seems somewhat confusing then please do say so and I/we'll be more than happy to help you on a level that you are able to understand.

__________________
The man who comes back through the Door in the Wall will never be quite the same as the man who went out.

Yes, that does help a little.
Let me explain

I have created following type structure

(1) Id - Integer
(2) name - 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


-Root Category
--Category
---Sub Category
----Sub Sub Category

Also, thank you for the warm welcome, I just found out about this site and there seems to be some extremely good PHP programmers here that I can learn from.

Why is it limited to only one table? Even Wordpress uses 3 tables for categories. :|

If you feel adventurous enough, have a go at the modified pre order tree traversal: http://www.sitepoint.com/article/hie...ata-database/2

I want to create a forum system, faq system, downloads, gallery, etc, and I don't want to use a table for each category, I would rather have all their categories controlled by one table, it would be a lot better than having, two or more tables for each module.


This helps, thank you, I think i'm starting to get an idea on how to do this.

Here is some other juicy information on the topic: http://dev.mysql.com/tech-resources/...ical-data.html

This is exactly what I needed, it has the same table structed as what I was going for. I'm just having a little trouble with the php code. Thanks for this resource though, much appreciated.

No problem man.

Are you going for the Adjacency List Model?

Yes I am going for the Adjacency List Model.
With using their provided table structure I want to make a tree, i think from then on I can figure out the rest, but I can't form it into a tree.

What's your question exactly?

What the loop should look like to display categories and sub categories in a tree with one table called categories

i'm still troubled on making the loop, i tried on my own and i still can't do it.