title: PHP and MySQL: Number of rows returned
body: <p>How can I see how many rows the following query returns?</p>
  
  <pre><code>mysql_select_db($database_aoldatabase, $aoldatabase);
  
  $query1 = "select * from sale where secid  = $invoiceno ";
  $query2 = "select * from sale where secid  = $invoiceno ";
  
  
  $maxa = mysql_query ($query1)
      or die ("Query '$query' failed with error message: \"" . mysql_error () . '"');
  $maxa2 = mysql_query ($query2)
      or die ("Query '$query' failed with error message: \"" . mysql_error () . '"');
  
  $row = mysql_fetch_array($maxa);
  $row2 = mysql_fetch_array($maxa2);
  </code></pre>