I have a query:

```
$myData = $db->query("
         SELECT * 
         FROM t1
         WHERE event = '$eid'
         ", PDO::FETCH_OBJ);

```

that returns results in an a form of an array:

```
Array (
[0] => stdClass Object
    (
        [id] => 1
        [even] => 1
        [response] => NO
        [adult] => 
        [child] => 
    )

[1] => stdClass Object
    (
        [id] => 2
        [event] => 1
        [response] => YES
        [adult] => 1
        [child] => 3
    )
)

```

I need to get the following counts:

Total for each response: YES and NO
If YES:
 Total Adults 
 Total Children

Can I get it from a query or do I need to manipulate the array to get the counts?