Contributions

Corrected to accommodate "pending" Wordpress posts. Full package.

Full package update for use with Wordpress Version 2.3.3

Given Category ID, retrieve most recent post, using relationships between wp tables
wp_terms
wp_term_taxonomy
wp_term_relationships
and
wp_posts

Corrected again - should now work with WP 2.3+

Scott

full package

This should work with Wordpress 2.3+ - please let me know if you have issues. (thanks to elcidd)

Scott
olsonsp4c

http://michaelwender.com/2006/10/06/embedding-wordpress-into-os-commerce-part-ii/

because in the new wordpress 2.3+ there are no categories insted there is ataxonomy so you should use wp api to get the category list.

This is an update to shindakun's version. I prefer this version because I can use it as a teaser to the full blown blog.

---------------
Changes
---------------
1. Updated script to query the email properly and made the layout nicer ( in my humble opinion ;)
2. Fixed the A with the little carrot over it issue in converting from sql to php-html output.

Hope you enjoy the changes - I've included an updated screenshot to give you the feel.

Scott (olsonsp4c)

A complet rewrite of the original script that changes it to display the wordpress posts in a file (blog.php) and also displays posts from all categories and shows the 10 most posts, making now reference to the orignal wordpress backend.

Version 1.1 Change Log:

Updated script for use with Wordpress 2.0.

Background
_______________________ _ _
For my upcoming store I wanted more then just a similar themed blog section. I wanted a more integrated feel. So, I decided to do away with the 'customer greeting' on the osCommerce index
page and replaced it with the latest post from a Wordpress blog running on the same MySQL database.

There is a small example picture in the zip.