title: Using DISTINCT and COUNT together in a MySQL Query
body: <p>Is something like this possible:</p>
  
  <pre><code>SELECT DISTINCT COUNT(productId) WHERE keyword='$keyword'
  </code></pre>
  
  <p>What I want is to get the number of unique product Ids which are associated with a keyword. The same product may be associated twice with a keyword, or more, but i would like only 1 time to be counted per product ID</p>