Wordpress - exporting titles with certain tags to html page

[Angelo22]

So, need a hand here as I can't seem to get this working

Situation:
Website is in html (php enabled via htaccess)
Wordpress is in a subdirectory.
Being a review site, each html page focuses on a single model/site.
The blog posts include new galleries and/or promos for the various sites.

What needs to be done:
Each blog post is tagged only with the model/site name. I'd need to have the list of all the titles with that tag to be listed on the respective review page (linked of course).

Example:
Html pages - cat, dog, fish, dinosaur
Blog posts - lucky (tagged "dog"), mittens(tagged "cat"), rex(tagged "dinosaur"), fluffy(tagged "cat"), goldfishie(tagged "fish"), brick(tagged "dog"), chuck (tagged "cat")

The page "cat" would have content about cat, and each of the blog posts tagged as cat somewhere: listing only mittens, fluffy, and chuck. (and any other post i tag as "cat" in the future)

Like...
Header
content
photo
content
content
photo
List of blog titles tagged "cat"
Footer

----------
Link to the site I need this for is in sig. Is there a widget or script that does it? Tried looking around but didn't find anything useful.

Any help is appreciated... thanks!

[L365]

Hi,

Try wordpress plugin - Yet Another Related Posts Plugin (YARPP).

wordpress.org/plugins/yet-another-related-posts-plugin

Cheers.

[sarettah]

I don't know that you would find any plugin to do this. You are not inside wordpress when you are on the review site (at least I don't think so). You might be able to do something with rss from wordpress pulled into the page, again not sure on that.

You could pull directly from the wordpress database at the top of each review page for whatever tag you want for that page.

Using my wife's wordpress blog (I am not sure what version) the sql would be something like:

select a.guid, a.post_title from wp_posts a
inner join wp_term_relationships b on a.id=b.object_id
inner join wp_term_taxonomy c on b.term_taxonomy_id=c.term_taxonomy_id
inner join wp_terms d on c.term_id=d.term_id
where c.taxonomy='post_tag' and d.name='tag to match to'

.

[sarettah]

I have an object put together that should be able to do this for you. Let me know if you want it.

.

[Angelo22]

Originally Posted by L365

Hi,

Try wordpress plugin - Yet Another Related Posts Plugin (YARPP).

wordpress.org/plugins/yet-another-related-posts-plugin

Cheers.

Does it allow me to show it on the html page? it looks like one of the many similar plugins that only work on the blog itself but not outside of it...

Originally Posted by sarettah

I don't know that you would find any plugin to do this. You are not inside wordpress when you are on the review site (at least I don't think so). You might be able to do something with rss from wordpress pulled into the page, again not sure on that.

You could pull directly from the wordpress database at the top of each review page for whatever tag you want for that page.

Using my wife's wordpress blog (I am not sure what version) the sql would be something like:

select a.guid, a.post_title from wp_posts a
inner join wp_term_relationships b on a.id=b.object_id
inner join wp_term_taxonomy c on b.term_taxonomy_id=c.term_taxonomy_id
inner join wp_terms d on c.term_id=d.term_id
where c.taxonomy='post_tag' and d.name='tag to match to'

.

I don't think so either - i'll try doing that with sql, though it might take a while as i'm not an expert in this. Thanks

Originally Posted by sarettah

I have an object put together that should be able to do this for you. Let me know if you want it.

.

Maybe Please send me an email - thank you

[David-PD]

You need to create a plugin for this if you want to do it via Wordpress intrerface... imo it's also the easiest way.

I can help you out.

[Angelo22]

PROBLEM SOLVED

In case anyone else needs the solution, just let me know =)

[sarettah]

Originally Posted by Angelo22

PROBLEM SOLVED

In case anyone else needs the solution, just let me know =)

Could you tell us what you did. High level, no detail needed. Thanks

.