home: cat1 > cat2 > cat3

[Anon]

Hi!

i want to know what is the most powerfull way to do something like this.

I have one table with 3 columns (id_cat,name,id_parent)

Then i have many entries in this table like this:

1, cat1, 0
2, cat2, 1
3, cat3, 1
4, cat4, 0
5, cat5, 4

etc....

I wan't to output something like this

home: cat1 > cat3

or

home: cat4 > cat5

I can use or PostgreSQL or mySQL, tell me which is better for this.

I make some program by myself but i don't like it, because i have a lot of queries. If i have path home: catx > caty > catz > catw i have like minimum 4 queries.

So i wan't to know if there is any other way to do this.

[Anon]

Are the categories to be nested arbitrarily deep?

(In other words, would you ever have

cat127 > cat99 > cat72 > cat55 > cat11 > cat5

or will you restrict it to just a few deep? )

You're trying to force a heirarchial model on top of a relational one, and it's not terribly efficient.

If you need a comprehensive list of all categories and their heirarchy, you can reduce the # of queries by working from the top down, rather than the bottom up.