在sql中通过while循环无法获取计数值？

Question

I need to get the users who sends the message count as well.

$userlist = mysql_query("select count(distinct m.subject) as msgcnt, u.name from message as m, message_users as mu, users as u where m.owner_id = u.id and m.id=mu.msg_id and mu.user_id='$u_id'group by name") or mysql_error();
        while($row=mysql_fetch_array($userlist))
        {               
            echo $row['name']."<br />";
        }

How to get the count values by using while loop..

Answer 1

You already are storing the said count in an alias msgcnt, simply echo it.

while($row=mysql_fetch_assoc($userlist))
        {               
            echo $row['name']." : ".$row['msgcnt']."<br />";
        }