How to query blog post in multisite?

  • How can I query the latest post in a multisite setup? Note that I want to display the post from a on the main site. I’ve looked into the rss technique and that will not give me custom field data which is required. Please help. No one ever responds.

    Mainsite -> query post in subsite -> display in main site

    I was thinking about writing a custom query for the specific table wp_2_posts but can not find a good example. Not even sure if this is possible.

    Thanks

Viewing 3 replies - 1 through 3 (of 3 total)

  • No, you don’t use a custom query.

    No one ever responds.

    really?

    Also, if you had searched this section of the forum, you’d see hundreds of questions asking this same thing, and almost every one suggests the use of the sitewide tags plugin, which will also pull custom fields.

    this is also mentioned in the multisite section sticky post.
    https://www.ads-software.com/support/topic/welcome-to-the-multisite-forum?replies=2

    I was thinking about writing a custom query for the specific table wp_2_posts but can not find a good example. Not even sure if this is possible.

    Sure it is. Do a siwtch_to_blog with a value of 2, and then a regualr post query.

    <?php switch_to_blog(2); ?>
    // do stuff
    <?php restore_current_blog(); ?>

    I’ve also mentioned countless times how pulling feeds back & forth across the network is not recommended.

    Thread Starter NewYorkCityZoo

    (@newyorkcityzoo)

    That solution was so simple. I think I over thought the solution this time. Thanks for your help Andrea_r. I appreciate all the work you put into this project.

    I agree – it is pretty hard to get any response for obscure questions around here. WP 3.0 in sitewide mode is basically WPMU, which very few people run – so support is limited. switch_to_blog() has been around since WPMU for a long time but, if you do anything intensive with it (e.g. scanning hundreds of blogs), it will chug extra RAM and take a long time to process. If you plan on doing anything serious with the homepage “blog”, cache each section in the WP database using a cron job. I’ve got a cron job that takes 12 seconds to execute that regenerates the necessary (serialized) pieces for the homepage blog. I wouldn’t want to drop any of that code on the homepage because it would kill the server.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘How to query blog post in multisite?’ is closed to new replies.