Compare two columns?

[xeirus]

Hi!
I have a table called "Categories"

Here is the structure:
id | Categories | ParentCategories
1 | Rings | Parent Category
2 | Pendants | Parent Category
3 | Ladies Rings | Rings
4 | Ladies Pendants | Rings
5 | Gents Rings | Gents
6 | Necklaces | Parent Category

But Necklaces is one of those who is not going to have any subcategories or you can say, it is going to be a category by itself.

So how can I construct a php statement to get data out of MySQL to determine that Necklaces is a Category which does not have subcategories.

Please help !

Thank you !

• Xeirus.

[dagon]

i have this page permanently bookmarked

Managing Hierarchical Data in MySQL

The section you want to go down to is "Finding the Depth of the Nodes"