title: php - mysqli count rows with specific value
body: <p>At the moment I'm able to count all the record's in a table with the value <em>"Waiting"</em>. This is done by using:</p>
  
  <pre><code>$query = "SELECT COUNT(*) AS SUM FROM jobs WHERE status='Waiting'";
  </code></pre>
  
  <p>When I want to echo the row count I just do: </p>
  
  <pre><code>echo $rows['SUM'];
  </code></pre>
  
  <p>How can I do it so it also count's all the record's in a table with the value <em>"Ready"</em>?</p>