MySQL count

[Thomisback]

Hi,

 

I am trying to execute a MySQL query to find out how many members a game has, let me show you an example:

 

members          owner

 

12                  admin

39                  john

1                    john

21                  admin

 

How can I count up the total members from the same owners?

I have already tried various counts querys but they still do not count up the members from the same owners.

 

Thank you!

[BillyBoB]

Try this:

<?php
$i = 0;
$select = mysql_query("SELECT * FROM table");
while($info = mysql_fetch_array($select)) {
   if(array_key_exists($info['owner'],$users)) {
      $users[$info['owner']] = $users[$info['owner']] + $info['members'];
   }else{
      $users[$i] = $info['owner'] => $info['members'];
   }
}
print_r($users);
?>

 

I hope this helps you I hand coded this in the textbox so there may be some errors.

[Thomisback]

Thanks a lot, going to try it now