Can I call that using get_blog_details();
?
It’s not on the codex page (https://codex.www.ads-software.com/WPMU_Functions/get_blog_details)
Here’s my code so far:
<?php
global $wpdb;
$query = "SELECT blog_id FROM " . $wpdb->base_prefix . "blogs WHERE spam != '1' AND archived != '1' AND deleted != '1' AND public = '1' AND blog_id != '1' ORDER BY path";
$blogs = $wpdb->get_results($query);
foreach($blogs as $blog){
$blog_details = get_blog_details($blog->blog_id); ?>
<div class="item">
<a href="<?php echo $blog_details->siteurl ?>">
<img class="item-img" src="<?php bloginfo('template_url'); ?>/img/placeholder-item.png" alt="item"/></a>
</a>
<a href="<?php echo $blog_details->siteurl ?>"><h2><?php echo $blog_details->blogname ?></h2></a>
<p><?php echo $blog_details->blogdescription ?></p>
<p><a href="<?php echo $blog_details->siteurl ?>">Check out their site »</a></p>
</div>
<?php } ?>