Permutations

Hi everybody.

I can't find the solution to this problem.

I have different categories of text data:

1) Website
2) Section
3) Position of the ad
4) Size of the ad
5) Type of the ad

And I would like to find out all possible permutations (I need to insert them in a catalog!) but the structure of any permutation must respect the hierarchy I wrote: I need all permutations where I have:
Website>Section>Position>Size>Type
and I don't want other orders
Section>Type>Website>Position>Size

For example, if I have:

1) Website: facetool.com, googland.com
2) Section: news, travel, love
3) Position of the ad: top, bottom
4) Size of the ad: 300x250, 990x250
5) Type of the ad: standard, special

I need a list like this:
facetool.com>news>top>300x250>standard
facetool.com>news>top>300x250>special
facetool.com>news>top>990x250>standard
facetool.com>news>top>990x250>special
facetool.com>news>bottom>300x250>standard
facetool.com>news>bottom>300x250>special
facetool.com>news>bottom>990x250>standard
facetool.com>news>bottom>990x250>special
facetool.com>travel>top>300x250>standard
facetool.com>travel>top>300x250>special
facetool.com>travel>top>990x250>standard
facetool.com>travel>top>990x250>special
facetool.com>travel>bottom>300x250>standard
facetool.com>travel>bottom>300x250>special
facetool.com>travel>bottom>990x250>standard
facetool.com>travel>bottom>990x250>special

... and the same for googland.com

The reality is I have many more websites, sections, positions, sizes and types, that is why I need to automate this. Can you tell me please how can I do it?

thank you
zik

Thank you! But when I update the source tables and then refresh, there is an error message saying something like the initialization didn't work out, check the database server and repeat"

No, I made some changes and now it works,thank you so much, I wish you a good day sir