halukkaramete at gmail.com
Sat Jun 13 20:27:47 UTC 2015
Actually using wpdb->get_results could have just done the job for me ( but
I need a more complex SQL that a simple one as follows )
$SQL = "
WHERE ( other_prefix_posts.ID < 10 )
AND other_prefix_posts.post_status = 'publish'
AND other_prefix_posts.post_type = 'post'
ORDER BY other_prefix_posts.post_date DESC
$posts = $wpdb->get_results($querystr, OBJECT);
This won't cut my need cause I need post_tags and category terms sprinkled
over this SQL & that's where the buck stops.
On Sat, Jun 13, 2015 at 9:02 AM, Stephen Harris <contact at stephenharris.info>
> This method isn't without it's difficulties, because of caching and
> globals and the like.
> You could attempt to mimic WordPress' switch_to_bog() adapted for a
> non-multisite instance. E.g. flush cache, reinitialise use roles etc. This
> would involve flushing the cache completely
> ($wp_object_cache->switch_to_blog()) won't work here because you're not in
> a multisite environment).
> But I'm not convinced it would be plain sailing from there either :).
> Depending on what is required, simply reading the first site's RSS feed
> and rendering that might the most straightforward solution.
> On 13/06/15 14:04, J.D. Grimes wrote:
>> Depending on what you are doing, you might not want or need multisite. In
>> that case, this should work:
>> $old_prefix = $wpdb->set_prefix( $site_1_prefix );
>> // get posts, etc., here.
>> $wpdb->set_prefix( $old_prefix );
>> See wpdb::set_prefix():
> wp-hackers mailing list
> wp-hackers at lists.automattic.com
More information about the wp-hackers