mysql help

[avatar.alex]

little problem this seems to only post the most reacent person to post a blog and I wanted a member listing so how could this be done....

 

<link rel="stylesheet" href="style.css" type="text/css"><center><table border='0' width=100%><tr><td valign='top' width=30%>
<?PHP
include "connect.php";
//now grab the latest updated blogs$getblogs="SELECT a.username, max(b.realtime) as maxtimefrom bl_blog b, bl_admin a where a.adminid=b.author group by a.adminidorderby maxtime desc limit 10";

$getblogs2=mysql_query($getblogs) or die(mysql_error());while($getblogs3=mysql_fetch_array($getblogs2)){
include "left.php";   
print "</td>"; 
  print "<td valign='top' width=70%>";
print "<table class='maintable'><tr class='headline'><td><center>Main Admin</center></td></tr><tr class='mainrow'><td><A href='/blog/members.php?membername=$getblogs3[username]'>$getblogs3[username]</a><br></td></tr></table>"
;print "</td></tr></table>";}
?>