MultiDimensional Array Count

[claudfs]

This is how my db structure looks, i have around 350 rows like this one below each with a different number of comment_list and likes from friends.


All i want is a query that counts how many times each variable comes up in the db.

For example if we ran the query in this script we would get:

1.) 65653171 (3 Times)
2.) 67418530 (1 Time )

etc...

Any Ideas???

 [0] => Array

                (
                    [viewer_id] => 65653171
                    [source_id] => 65653171
                    [actor_id] => 65653171
                    [comments] => Array

                        (

                            [comment_list] => Array
                                (
                                    [0] => Array
                                        (
                                            [fromid] => 67418530
                                        )
                                    [1] => Array
                                        (
                                            [fromid] => 108832181
                                        )
                                )
                        )
                        
                    [likes] => Array
                       
                       (
                            [friends] => Array
                            (
                                [0] => 58579401
                                [1] => 55125266
                                [2] => 57449386
                                [3] => 60906602
                                )
                            )
                        )

[r937]

sorry, a database table does ~not~ look like a php array

please show actual sample rows of data

[claudfs]

$query = "SELECT post_id, actor_id, comments, likes FROM stream WHERE source_id = ".$user." LIMIT 500";
$result = mysql_query($query);
$count = count($result);
$total=$count;


 for ($i = 0; $i < $count; $i++)
 {

 $actor_id = $result[$i][actor_id];
$count_c  = $result[$i][comments][count];

if($count_c > 0){
    for ($a = 0; $a < $count_c; $a++){
          $comment_id = $result[$i][comments][comment_list][$a][fromid];

    }
}

 
$count_l  = $result[$i][likes][count];

if($count_l > 0){       
        for ($b = 0; $b < $count_l; $b++){
            $likes_id = $result[$i][likes][friends][$b];
       
   }       
}

That query would return: ( Each of these integers represent a unique user id )

65653171
67418530
108832181
58579401
55125266
60906602

Now when i run this query on my DB i'll get around 500 different users id's, but lots will be duplicates.
Some will appear 10 times, some 34 times, some 5 times.
All i want is to calculate the number of times they each come up??
Know what i'm saying??

[r937]

Know what i'm saying??

no i don't!!!

i understand the SQL -- and remember, this is the MySQL forum, not the php forum -- but the stuff that comes after it might as well be in sanskrit

[claudfs]

Lol sorry i just edited it to make more sense i'm sure you will understand now..

[r937]

All i want is to calculate the number of times they each come up??

now i do

SELECT actor_id
     , COUNT(*) AS number_of_times
  FROM stream 
 WHERE source_id = ".$user."
GROUP
    BY actor_id

[claudfs]

This is for a Facebook Application, and when doing a FQL Query on the DB facebook does not allow GROUP BY and COUNT in the query it self..

Is there another way to do it??

Thanks

[r937]

facebook does not allow GROUP BY and COUNT in the query it self..

well, ~that's~ pretty lame