I am trying to display a list of existing blogs in a blogs network without using the blogs directory (for design considerations) plugin, taking in consideration that I must display (Blog Title, Blog Tagline, Blog URL).
So, after searching the forum and looking inside the blogs directory plugin, I've reached the following code:
$query .= "SELECT * FROM wp_blogs WHERE spam != 1 AND deleted != 1 AND blog_id != 1"
$query .= " ORDER BY domain ASC"
Unfortunately the above code will return only to me (domain) field which represent the Blog URL, but it will not return for me Blog Title or Blog Tagline.
So can someone please advice me how I shall modify the above mentioned SQL to display the (Blog Title, Blog Tagline and Blog URL)?
Thanks in advance for your time and efforts