Display posts in [category] AND [tag]

  • I’m using WP as a content management system for a directory of merchants, where I have used tags as cities and categories as… well, categories.

    I have set the site up so that I have dropdowns to show all posts within a city (tag) and category.

    My goal is the following:

    • To display all posts within X category AND Y tag
    • Preferably, this would be in a friendly permalink kind of way, for instance https://[site]/tag/%5Btag%5D/city%5Bcity%5D or even better, https://[site]/%5Btag%5D/%5Bcategory%5D, so the example would be https://www.yoursite.com/newyork/restaurants would display all posts with the tag=new york and category=restaurant
    • I’d also like to include something, preferably in the sidebar when displaying all the posts for a tag, that shows me a list of all the categories that have posts and also that tag. For instance, when viewing New York, the sidebar would display Restaurants, Bars, Office supplies, etc in the sidebar and/or right on the page, so that the user can drill down further.
    • Also, if possible, I’d love to be able to do the opposite, even though this is not as important. But simply display all the tags per category. So after selecting restaurants, the user can see all cities that have restaurants in them.

    I know that WP is a blogging software, and that this wasn’t its intention. However, I’ve successfully migrated all the content from an old site, and the admin UI in WP is unbeatable. If I could get this to work, together with a good way to do sorting (some featured posts should be on top in the category/tag views which I think I can find a plugin to do), I’m there…

    Any help and/or suggestions would be appreciated. I’m even willing to pay someone to develop a plug-in that accomplishes the above.

Viewing 7 replies - 1 through 7 (of 7 total)
  • Moderator Samuel Wood (Otto)

    (@otto42)

    www.ads-software.com Admin

    This is not yet possible. WordPress simply can’t handle the query properly.

    2.7 may introduce new fixes to help with this, but it won’t have permalink capabilities like you’re talking about there.

    Thread Starter wpsr

    (@wpsr)

    Thank you for the quick and straight up answer! Is there any way to do it today without the permalinks? Are, for instance, any of these possible:

    • When going to a City, display all the categories with posts as headers with links to all the posts under each header
    • Two drop-downs (category and tag) and a GO button that submits some sort of a form, which would show only posts within that tag and category (city and category in case).

    I saw this post and was wondering if I’d be able to use any of that code? https://www.ads-software.com/support/topic/152904?replies=34

    Thread Starter wpsr

    (@wpsr)

    Or can I create some sort of a custom query?
    https://codex.www.ads-software.com/Displaying_Posts_Using_a_Custom_Select_Query
    Sorry, this is a little bit over my head… Thank you so much for any help anybody can provide.

    Thread Starter wpsr

    (@wpsr)

    Basically, and sorry if I wasn’t clear enough in my previous post, is there an easy way to display the following on a tag page – so, for New York only (NY being a tag):

    Restaurants (category)

    • Post1
    • Post2
    • Post3

    Hardware stores

    • Post4
    • Post5
    • Post6

    Post 1,2,3 would be Restaurants in NYC, and Post 4,5,6 would be Hardware stores in New York. Any ideas?

    Thread Starter wpsr

    (@wpsr)

    Friendly bump…

    I would love to know if this is possible as well.

    Couldn’t you just use multiple categories for the post? Not an ideal situation in terms of permalinks, but if you had the funding to hire a programmer, it could be done. The functionality, however, seems feasible. If you have a post that is a hardware store in new york, you’d set hardware store and new york as the categories, and your query would simply have cat=1,2.

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Display posts in [category] AND [tag]’ is closed to new replies.