I am trying to pull several posts from a WordPress installation on one server (let's call it Server1) into a page template in a separate WordPress installation another server (Server2). MySQL access should not be a problem between the two servers. But I am having trouble figuring out how to connect the two databases and execute the query.
Ideally I would like to create a custom page template on Server2 that loads up WordPress as normal, but when it's time to get the_content, it executes a query_posts that pulls out all the posts (including Custom Fields) from a specific category from Server1 instead.
Or is XML-RPC better for this sort of thing? And if so, where do I get started with that?
Many thanks.