title: "how many search results from mysql" help
body: <p>I got some help with gettin the number of rows returned from mysql, and it works fine...
  BUT, how do I get the number of rows with a certain field value?
  Do I have to make a new Mysql search query?</p>
  
  <p>Here is the code where I query mysql and display in a table using fetch_array... Also, Im using mysql_num_rows to get number of rows.
  So how do I get number of rows with certain field value also?</p>
  
  <pre><code>$qry_result = mysql_query($query) or die(mysql_error());
  $num_rows = mysql_num_rows($qry_result);
  while($row = mysql_fetch_array($qry_result))
  </code></pre>
  
  <p>Thanks for all help</p>
  
  <p>OBSERVE: Im trying to avoid using another SELECT WHERE clause...
  Is there a way to do what I want withouth another search?</p>