title: MySQL / PHP: Fetch multiple values from 1 column in Database
body: <p>I'm trying to select multiple values from 1 column in my MySQL database. I have a Table 'products' with a column 'category'. Categories: Home, Garden, Cars, Bicycle etc. I want to fetch the number of products with these categories for statistics. It sounds simple but I can only get it done with allot of code. I want all of these categories to be variables so I only have to put my variables in my statistics engine to do the calculation. Right now this is my code to fetch the number of products with category 'Garden':</p>
  
  <pre><code>$query = "SELECT * FROM products WHERE category='Garden'";
  $result= mysql_query($query);
  $row   = mysql_fetch_array($result);
  
  echo "$row[category]";
  </code></pre>
  
  <p>Repeating this for every category does 't seem right to me.. Does anyone understand my question and have a solution?</p>