Forum Moderators: mack
X, Y, Z
Category Z has 10 subcategories: Z1, ...Z10
Every entry is filed under either X or Y, plus one of the subcategories of Z.
Under the margin of the entry I want to list related entries. By "related" entry, this is what I mean specifically:
If the entry is filed under categories X and Z1, I want to list all other entries that are filed under categories Y and Z1. (note: Y was substituted for X)
If the entry is under X and Z2, I want a list of all other entries that are under Y and Z2.
If the entry is under X and Z3, I want a list of all other entries that are under Y and Z3....etc until you reach Z10.
If the entry is under Y and Z1, I want a list of all other entries that are under X and Z1.
If the entry is under Y and Z2, I want a list of all other entries that are under X and Z2.
If the entry is under Y and Z3, I want a list of all other entries that are under X and Z3....etc until you reach Z10.
I need a nice, elegant way to do this - probably an if/then loop which does this:
For every entry with subcategory Z1-->Z10:
If entry is under categories X and Zx, then display other entries in categories Y and Zx.
Will appreciate your help. Thanks.
blog/database/web server/language
you looking for people to reply with an sql statement?
