[wp-hackers] Showing posts from multiple WP sites on a single site

[Randy Peterman]

This requires a query that
1) knows all of the WordPress installations tables and then calls for 
data from all of those tables something like (this is from my head, and 
not from the WordPress code)

SELECT (* or data set) FROM wp_posts, wp2_posts, wp3_posts, wp4_posts 
WHERE (code to filter the results as needed)

This would be a custom hack job if there ever was one because you could 
have a lot of complication depending on what you were after.

A 'Simplified' Multiple WordPress installations may have an extra field 
for all tables that specify a blog number and run everything out of one 
table-set.  So that if the blog ID is not specified then all blog data 
is shown, but if a blog_id is set, then it just returns results for that 
one blog.  That of course would require a totally different set of code 
and would require WordPress to be heavily re-coded to handle such 
things.  Options for blogging would be multiplied as well which means 
that things would be much more complicated.

Regards,
Randy Peterman