title: Subquery returns more than 1 row
body: <p>im geting this error when trying to do 2 counts inside of my query</p>
  
  <p>first ill show you the query:</p>
  
  <pre><code>$sql = mysql_query("select c.id, c.number, d.name, 
                      (select count(*) from `parts` where `id_container`=c.id group by `id_car`) as packcount,
                      (select count(*) from `parts` where `id_container`=c.id) as partcount
                      from `containers` as c
                      left join `destinations` as d on (d.id = c.id_destination)
                      order by c.number asc") or die(mysql_error());
  </code></pre>
  
  <p>now the <code>parts</code> table has 2 fields that i need to use in the count:
  <code>id_car</code>
  <code>id_container</code></p>
  
  <p><code>id_car</code> = the ID of the car the part is for
  <code>id_container</code> = the ID of the container the part is in</p>
  
  <p>for <code>packcount</code> all i want is a count of the total cars per container
  for <code>partcount</code> all i want it a count of the total parts per container</p>