Wordpress - exporting titles with certain tags to html page - GoFuckYourself.com

Angelo22 · 12-20-2013, 12:41 AM

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 · 12-23-2013, 12:36 AM

Hi,

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

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

Cheers.

sarettah · 12-25-2013, 08:37 PM

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 · 12-26-2013, 12:49 AM

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

.

Angelo22 · 12-26-2013, 02:15 AM

Quote:

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...

Quote:

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

Quote:

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 · 12-26-2013, 05:34 AM

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 · 12-26-2013, 07:49 AM

PROBLEM SOLVED

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

sarettah · 12-26-2013, 09:08 AM

Quote:

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

.

12-20-2013, 12:41 AM	#1
Angelo22 Writer Industry Role: Join Date: Feb 2007 Posts: 3,123	Wordpress - exporting titles with certain tags to html page 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! __________________ MAKE MORE MONEY FROM YOUR WEB TRAFFIC - 15% BONUS And contact me if you need high quality translating and writing work done - angelo22 (AT) gmail (DOT) com

12-25-2013, 08:37 PM	#3
sarettah see you later, I'm gone Industry Role: Join Date: Oct 2002 Posts: 14,055	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' . Last edited by sarettah; 12-25-2013 at 08:50 PM..

12-26-2013, 05:34 AM	#6
David-PD Confirmed User Industry Role: Join Date: Nov 2013 Posts: 234	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. __________________ PornDeals.com - WebcamDeals.com - GayDeals.com - PornCoupons.com new! david{att}porndeals{dott}com (email) porndeals.d (skype) -- Looking for HQ hardlinks in all niches!!! -- Looking to buy websites with income & stable traffic! Contact me if you have something interesting

12-26-2013, 07:49 AM	#7
Angelo22 Writer Industry Role: Join Date: Feb 2007 Posts: 3,123	PROBLEM SOLVED In case anyone else needs the solution, just let me know =) __________________ MAKE MORE MONEY FROM YOUR WEB TRAFFIC - 15% BONUS And contact me if you need high quality translating and writing work done - angelo22 (AT) gmail (DOT) com Last edited by Angelo22; 12-26-2013 at 08:02 AM..

12-23-2013, 12:36 AM	#2
L365 Registered User Industry Role: Join Date: Oct 2013 Posts: 7	Hi, Try wordpress plugin - Yet Another Related Posts Plugin (YARPP). wordpress.org/plugins/yet-another-related-posts-plugin Cheers.

12-26-2013, 12:49 AM	#4
sarettah see you later, I'm gone Industry Role: Join Date: Oct 2002 Posts: 14,055	I have an object put together that should be able to do this for you. Let me know if you want it. .