Welcome to WebmasterWorld Guest from 54.146.248.111

Forum Moderators: brotherhood of lan & mack

Message Too Old, No Replies

Help with MT 4.1

     

4more

6:16 pm on Apr 26, 2008 (gmt 0)

5+ Year Member



My blog has 3 categories:

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.

dbdev

1:07 pm on Apr 30, 2008 (gmt 0)

10+ Year Member



details?

blog/database/web server/language

you looking for people to reply with an sql statement?

 

Featured Threads

Hot Threads This Week

Hot Threads This Month