WordPress Show List of Recently Created Blogs

Show off all of your latest blogs. Insert into your functions:

 
<?php 
/*Fetch an array of $number_blogs most recently created blogs
**@number_blogs :The number of most recently created blogs you want to show. 
*/ 
function get_recent_blogs($number_blogs=5) 
{ 
 
global $wpdb; 
$blog_table=$wpdb->blogs; 
/*fetch blog_id,domain,path from wp_blogs table ,where the blog is not spam,deleted or archived order by the date and time of registration */ 
$query="select blog_id,domain,path from $blog_table where public='1' and archived='0' and spam='0' and deleted='0' order by registered desc limit 0,$number_blogs"; 
$recent_blogs=$wpdb->get_results($wpdb->prepare($query)); 
 
return $recent_blogs; 
} 
?>

Use the following to get its output:

 
<ul class="recent-blogs"> 
<?php $recent_blogs=get_recent_blogs(5); 
<span style="white-space: pre;"> </span&gt;foreach($recent_blogs as $recent_blog): 
<span style="white-space: pre;"> </span>$blog_url=""; 
<span style="white-space: pre;"> </span&gt;if( defined( "VHOST" ) &amp;&amp; constant( "VHOST" ) == 'yes' ) 
<span style="white-space: pre;"> </span>$blog_url="http://".$recent_blog->domain.$recent_blog->path; 
 
<span style="white-space: pre;"> </span&gt;else
 
<span style="white-space: pre;"> </span>$blog_url="http://".$recent_blog->domain.$recent_blog->path; 
 
<span style="white-space: pre;"> </span>$blog_name=get_blog_option($recent_blog->blog_id,"blogname"); 
<span style="white-space: pre;"> </span>?> 
<li> 
<h3><a href="<?php echo $blog_url;?>"> </a></h3> 
<span><?php echo $blog_name?></span> 
</li> 
<?php endforeach;?> 
</ul>