title: Get number of rows returned in MySQL query
body: <p>I'm having some trouble with a MySQL query I'm writing. I'd like to get a count of the number of rows that my query is returning without actually returning the rows and then using mysql_num_rows or the like.</p>
  
  <p>My query is as follows:</p>
  
  <pre><code>SELECT COUNT(l.product_number_language) as counts, l.id, l.product_number, l.language,    l.product_number_language
  FROM bs_products_languages l
  LEFT JOIN bs_products p ON (l.product_number_language = p.product_number)
  WHERE l.product_number = 'C4164' 
  AND l.active='Y'
  AND p.active='Y'
  GROUP BY l.language
  </code></pre>
  
  <p>The following is what is being returned:
  <img src="https://i.stack.imgur.com/Syjv3.png" alt="Screenshot"></p>
  
  <p>And what I really want is simply a count of these rows, so in this case 3.</p>