Counting articles in heirarical category system..

[listenmirndt]

This has had me stumped for a long time...

Here is the category structure :

Table name :CATEGORIES
Fields : ID,CATEGORY,TITLE

( where CATEGORY is the parent )

Here is my articles stucture:

Table name: LISTINGS
Fields, CATEGORY, (etc)

( CATEGORY has the ID of CATEGORIES table )

So your basic heirarical category system...

What I want to do is count the listings inside of the parent category... ( and the tricky part, all of it's subcategories also ... )

any tips would be great!

[devphp12]

u mean if category 1 has 3 chid 2,3,4

now 2 has 5,6,7

now 5 has 9,10

thne u wnat 1 have 3 child
2 has 3
5 has 2

3 has 0
4 has 0?

then u can use recursion

[listenmirndt]

Right, yes I have been looking into recursion...