function get_all_sites() { global $wpdb; // Query all blogs from multi-site install $blogs = $wpdb->get_results("SELECT blog_id,domain,path FROM wp_blogs where blog_id > 1 ORDER BY path"); // Start unordered list echo '

'; // For each blog search for blog name in respective options table foreach( $blogs as $blog ) { // Query for name from options table $blogname = $wpdb->get_results("SELECT option_value FROM wp_".$blog->blog_id ."_options WHERE option_name='blogname' "); foreach( $blogname as $name ) { // Create bullet with name linked to blog home pag echo '
• '; echo ''; echo $name->option_value; echo '
'; } } // End unordered list echo '

';