title: Counting the records in a certain table and displaying the results
body: <p>would this be the correct way to display the number or records in a particular table, I am just going to put this in an if statement so if there are more than 20 do something ?</p>
  
  <pre><code> $query = "SELECT COUNT(1) FROM mytable"); 
    $result = mysql_query($query) or die(mysql_error()); 
  
   $row = mysql_fetch_row($result); 
  
   echo $row[0];  
  </code></pre>