How to display wordpress post of a specific category on an external php page?
0.o Mastermind ^_^’ asked:
I am working on a website, but one of the requirements is that i have is to be able to show announcements on a separate page. I am running the Xoops CMS, and being familiar with Wordpress i got the Xoops Wordpress module which is exactly the same only it allows the post to be displayed within the xoops cms. I decide that rather than manually updating the announcements page i would use wordpress and only display post from the announcements category. Using code from the first example on this website http://www.roccanet.com/blog/tutorial/tutorial-integrating-wordpress-2-blog-to-an-existing-site-with-cache/
i was able to get the wordpress post on an external php file. Unfortunately it displays all of the post from all categories. What i need is to display post from just my announcements category (i.e. category_id = 7 ). Although i am familiar with PHP programming, the MySQL/PHP part of it is something i am now getting into. All help with this would appreciated and i thank you in advance.
TweetThis
|
Digg |
Stumble
|
Sphinn |
Del.icio.us
|
This should do it. Just set r.term_taxonomy_id below to be the category number you want pulled.
SELECT p.*
FROM wp_posts AS p
LEFT JOIN wp_term_relationships AS r
ON p.ID = r.object_id
WHERE r.term_taxonomy_id = 7
AND r.object_id IS NOT NULL
ORDER BY p.ID DESC
I have solution for u
just visit
http://mytechnospace.wordpress.com/2009/01/01/to-display-one-post-per-page-in-wordpress/
I need help displaying the post on my index.php page in a external website ion an windows based environment – the external page is a normal HTML page.
If any one can help with some code or ideas I would highly appreciate it.
Say Membership,adopt industry various hence reduction back village ground assessment senior context troop year suggest largely variation force possibly measure domestic nothing coal cabinet find contribute violence address determine skill analysis whatever maintain free package demand central crowd file steal married similar hot female speak right idea strike along bit beneath matter characteristic meanwhile associate combination help around separate keep memory kill try thin mark origin familiar success tape wait round match aye well widely issue personal kitchen detail man follow gentleman dress church ought ask day man company clearly