I have searched and tried about 10 different versions of a feature that would allow me to display the latest 10 posts from all of my sitewide blogs in one of my columns.
A few requirements:
1. Must be post title only.
2. Must be code- not a widget
3. Must have a link to the post
The closest code I found was this:
<h2>Last Updated</h2>
<div class="comments">
<ul>
<?
$blogs = $wpdb->get_col("SELECT blog_id FROM $wpdb->blogs WHERE domain!='beblogger.com' AND last_updated!='0000-00-00 00:00:00' ORDER BY last_updated DESC LIMIT 10");
foreach ($blogs as $blog) :
$blog = "wp_".$blog."_options";
$opt = $wpdb->get_col("SELECT option_value FROM $blog WHERE option_name='siteurl'");
$opt2 = $wpdb->get_col("SELECT option_value FROM $blog WHERE option_name='blogname'");
print "<li><a href='$opt[0]'title='$opt2[0]'>".ucfirst($opt2[0])."</a>";
endforeach;
?>
</ul>
</div>
The problem with this is that it didn't show the individual posts, only the blogs that the posts were made from.
Thanks So much in advance!!