title: How I can combine two query that will count rows?
body: <p>How can I combine this two query into one thank you in advance.</p>
  <pre class="lang-php prettyprint-override"><code>$mayorcountqry = $conn-&gt;prepare(&quot;SELECT VOTE_STATUS FROM voters where VOTE_STATUS = ? AND prcnt_no = ? &quot;);
  $mayorcountqry-&gt;execute([$MAYOR,$prcnt_no]);
  $countmayor = $mayorcountqry-&gt;rowCount();   
                                          
  $triocountqry = $conn-&gt;prepare(&quot;SELECT VOTE_STATUS FROM voters where VOTE_STATUS = ? AND prcnt_no = ? &quot;);
  $triocountqry-&gt;execute([$TRIO,$prcnt_no]);
  $triocount= $triocountqry-&gt;rowCount();
  </code></pre>