get all articles from parent category

[UnknownPlayer]

I have categories and sub-categories, related with sub_cat 0(parent) or with cat id(sub-cat), now articles are in sub-cats, cant be in parent cat, now  i need to select all articles from parent category,that means to select from all sub-cats of that parent categorie.

And articles are related with sub-cats.

Can someone help me ?

[fenway]

What?

[UnknownPlayer]

Example:

i have these categories(table categories):

- Cars (id = 1, sub_cat_id = 0)

- IT (id = 2, sub_cat_id = 0)

- Other (id = 3, sub_cat_id = 0)

sub_cat_id is 0, becouse these are parent categories

 

And in "Cars" category i have these sub cats(table categories):

- Mercedes (id = 10, sub_cat_id = 1)

- BMW (id = 11, sub_cat_id = 1)

- VW (id = 12, sub_cat_id = 1)

- BMW (id = 11, sub_cat_id = 1)

sub_cat_id is 1, becouse these are child categories of category "Cars" (id = 1)

 

And articles are(table articles):

- c200 (id = 1, cat_id = 10)

- e200 (id = 2, cat_id = 10)

- s500 (id = 3, cat_id = 10)

cat_id is 10, becouse "Mercedes" cat id is 10(child category) in table categories.

 

Now i need to select all articles from parent category "Cars" (id = 1)

 

Can someone help me ?

[UnknownPlayer]

Any help ?

[laffin]

First u need to build a hierarchy. Whether this is stored within the db or u build it dynamically.

than u can use this list of ids to pull the articles

[UnknownPlayer]

Can you give me example how u mean that ?

[mikosiko]

this presentation posted by fenway in the "The MYSQL sticky" long time ago is a must to be read... around slide 48 and up apply to your case.

http://www.slideshare.net/billkarwin/sql-antipatterns-strike-back

[UnknownPlayer]

Can  you give me example, i dont get ?

 

[UnknownPlayer]

I mean code for my problem if you can ?

[fenway]

If you're looking for code for your entire problem, you're in the wrong forum.

[UnknownPlayer]

Oh, then this is half-help-forum.

Thanks..