Can't get the count value through while loop in sql?

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..

$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(); query issue might be give space mu.user_id='$_id' group by — X-Factor
– X-Factor, Commented Mar 4, 2013 at 6:34

Hanky Panky · Accepted Answer · 2013-03-04 06:34:56Z

3

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 />";
        }

answered Mar 4, 2013 at 6:34

Hanky Panky

46.9k9 gold badges76 silver badges95 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Achrome · Accepted Answer · 2013-03-04 06:34:33Z

1

echo $row['msgcnt'].'<br/>';

answered Mar 4, 2013 at 6:34

Achrome

7,82114 gold badges38 silver badges45 bronze badges

Comments

silly · Accepted Answer · 2013-03-04 06:36:08Z

0

use mysql_fetch_assoc to get a associated array!

$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_assoc($userlist)) {               
        echo $row['name']."<br />";           
        echo $row['msgcnt']."<br />";
    }

answered Mar 4, 2013 at 6:36

silly

7,8972 gold badges27 silver badges37 bronze badges

Comments

Yogesh Suthar · Accepted Answer · 2013-03-04 06:36:36Z

0

use msgcnt when you specified alias as msgcnt

echo $row['msgcnt']."<br />";

answered Mar 4, 2013 at 6:36

Yogesh Suthar

30.5k18 gold badges75 silver badges100 bronze badges

Collectives™ on Stack Overflow

Can't get the count value through while loop in sql?

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related